Continual Changing Sheet Names

[SystemsAccountant]

Hi,

I want to capture data from another workbook each month where the sheet name that I need the data from changes each month.

i.e. 0810, 0811, 0812, 0901

Are possible sheet names.

I've tried to build this unsuccessfully into the my code:-

Please Login or Register  to view this content.

To try and define the sheet name, and then refer to it:-

Please Login or Register  to view this content.

Could someone please help?

Many Thanks
Matt

[royUK]

Something like this might do it

Please Login or Register  to view this content.

[SystemsAccountant]

Thanks Roy.

Unfortunately I can't work out what I need to do with your code in order for me to do what I would like to do.

Both the year and month need to be input by the user. I have two cells on a sheet ("VAR") where the user does this.

Therefore in the VB Code I want to select a sheet that is the name of these two cells added together.

First cell = Month. Name is "Month No" (e.g. 10)
Second cell = Year. Name is "CIRMSDYear" (e.g. 08)

The sheet name I want to select in the other workbook is "0810".

Regards
Matt

[royUK]

I think this is what you want

Please Login or Register  to view this content.

[SystemsAccountant]

Brilliant, thanks Roy.

[royUK]

Please mark the thread soklved & rate the answer(s)