I have been looking, without success, for some code that will open a large number of workbooks copy sheet1 and paste to my master workbook adding it as a new sheet (sheet2, sheet3 etc). Many thanks
I have been looking, without success, for some code that will open a large number of workbooks copy sheet1 and paste to my master workbook adding it as a new sheet (sheet2, sheet3 etc). Many thanks
Are they all in the same folder? If so, you can just run the directory
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
If they are in one folder, you could try this.
Please Login or Register to view this content.
I was talking about what Jolivanes has just posted
I am sorry to say this hasn't worked and the sheets aren't copying across however, it may because I said it was named sheet1 that needed copying but in fact the first sheet in each of the workbooks is named "Support Worker". Can someone advise the line of code that I need to change so this does work. Thanks
If you've attended to the path, then
ought to do itPlease Login or Register to view this content.
Oh xladept, I thank you for the response but you've now confused me again with "attended to the path", can you advise me on that as well? Thanks
If you have one of the books from the correct folder active, you could write:Please Login or Register to view this content.
Please Login or Register to view this content.
Xladept - thanks for the guidance- this is now working fine
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks