Parsing Rows of Data into separate tabs based on criteria

[Closed]
Report
Posts
1
Registration date
Friday September 20, 2013
Status
Member
Last seen
September 20, 2013
-
Posts
2786
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 5, 2021
-
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.

3 replies

Posts
2786
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 5, 2021
470
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
Posts
2786
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 5, 2021
470
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!