Macro for specific worksheets

[claire74]

Hi

I'm trying to amend my macro to only get data from a specific worksheet in multiple workbooks in a specific folder.

I have very basic knowledge so am lost with it.

This is the first bit of my code which currently means all worksheets in all workbooks are accessed rather than "sheet 1" which is all I want.

Any help much appreciated.

Please Login or Register  to view this content.

[PingPing]

You could try this:

Please Login or Register  to view this content.