harvest data from several workbooks

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
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,108,620
Messages
5,523,944
Members
409,543
Latest member
LaMaqu1na

This Week's Hot Topics

Top