Sheet reference based on inputbox value

[ben10]

Hi all

I am very new to VBA and am a little bit stuck. Any help would be appreciated!

I want to reference a worksheet using a value stored via an inputbox entry. Please see below macro.

Please Login or Register  to view this content.

Basically, I want to enter the sheet name into the inputbox (between 2001, 2002, 2003, etc), then the macro will select this sheet and paste the data.

Thanks for your help.

[:) Sixthsense :)]

Try like this...

Please Login or Register  to view this content.

[JOHN H. DAVIS]

From what I see, what you have should work?

[ben10]

That works very well. Thanks for your help Sixthsense!

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback