Parsing Rows of Data into separate tabs based on criteria

Closed
dzocchi Posts 1 Registration date Friday September 20, 2013 Status Member Last seen September 20, 2013 - Sep 20, 2013 at 05:01 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 24, 2013 at 10:43 AM
I have a master list of launches in excel, each which includes a column for launch date. For all launches with a launch date in September, I would like the full row replicated into a separate tab labeled September (Sept tab has all the same column titles as the master list). I would like for this to happen automatically any time a new launch is added to the master list AND I want information that is updated on the master list to automatically update in the separate monthly tabs.

I am not a developer and am a rookie with excel so a simple "if/then" function I can do but complex code is a little harder for me to understand. Any recommendations?

Also, I am working with Excel 2007.
Related:

3 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Sep 23, 2013 at 11:28 AM
Hi Dzocchi,

Have you considered the autofilter option?

Best regards,
Trowa
Hi TrowaD,

I'm not sure how the autofilter works, will it fitler the rows into separate tabs or just within the same one?

Any guidance helps... thank you!
D
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Sep 24, 2013 at 10:43 AM
Hi D,

Autofilter will filter data in the current sheet/tab.
Try it out and see if you like it.

If you don't then post your workbook using a site like www.speedyshare.com or ge.tt.
That way it is easier to write a code for you.

Best regards,
Trowa