Macro to take action on all sheets that come after specified sheet

[EmmaO91]

Hi everyone,

I have an excel Workbook made up of sheets that are named after months ("May 2014", "Jun 2014" etc). I want to pull data from each sheet that comes after a user specified date. Is there any way to do this?

Thanks in advance!

Emma

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[EmmaO91]

Ahh so you can specify sheets by number rather than by name. Interesting.

That's really helpful, thank you John

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.