tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Hope you can help me,
I have a situation where I need to copy all my stores into one document, so here what i was thinking
I save the active folding local, but we dont know it actual location,
however we do know that in that same folder are all the documents I need.
so I want a macro that when run goes to the folder the document is saved in and for ever document that is in there that is XLSX or XLSM
open the document, goto the tab Named "Sales" (they will all have a tab named sales but if it cant find one close and move on to next)
Colpy All Data in Columns A&B
now with the document, create a new sheet, paste that data into A1 and name the sheet the name of the document you opened for example if it was called "Tony Test.XLSX" the tab is Tony Test
do this for all the documents in the folder.
please help if you can
thanks
Tony
Hope you can help me,
I have a situation where I need to copy all my stores into one document, so here what i was thinking
I save the active folding local, but we dont know it actual location,
however we do know that in that same folder are all the documents I need.
so I want a macro that when run goes to the folder the document is saved in and for ever document that is in there that is XLSX or XLSM
open the document, goto the tab Named "Sales" (they will all have a tab named sales but if it cant find one close and move on to next)
Colpy All Data in Columns A&B
now with the document, create a new sheet, paste that data into A1 and name the sheet the name of the document you opened for example if it was called "Tony Test.XLSX" the tab is Tony Test
do this for all the documents in the folder.
please help if you can
thanks
Tony