stevebrook1
New Member
- Joined
- Jul 10, 2018
- Messages
- 1
Hi guys
I have a folder that contains several workbooks - each with an individual number
inside each workbook is a tab called STOCK
i want to be able to harvest all info in the stock tabs of each workbook - could I "consolodate"? or maybe a macro?
i will be wanting to do this action on a weekly basis
I could put either "call off" the required workbooks or put them into a specific folder and call off all workbooks inside a folder?
assuming this IS doable with little expertise i woudl then like the option of customising which columns or rows will be pulled off?
to confirm all the data i require will be pulled out a tab called the same name in every workbook
hoping for a bit of understandable advice
cheers
I have a folder that contains several workbooks - each with an individual number
inside each workbook is a tab called STOCK
i want to be able to harvest all info in the stock tabs of each workbook - could I "consolodate"? or maybe a macro?
i will be wanting to do this action on a weekly basis
I could put either "call off" the required workbooks or put them into a specific folder and call off all workbooks inside a folder?
assuming this IS doable with little expertise i woudl then like the option of customising which columns or rows will be pulled off?
to confirm all the data i require will be pulled out a tab called the same name in every workbook
hoping for a bit of understandable advice
cheers
