I am trying to create a "Master" workbook that consolidates data from mulitple workbooks. Each workbook has the same data format. Can someone tell me how to create this link between workbooks that are located on the same network location?
I am trying to create a "Master" workbook that consolidates data from mulitple workbooks. Each workbook has the same data format. Can someone tell me how to create this link between workbooks that are located on the same network location?
'WORKBOOKS TO 1 SHEET STACKED
Here's a macro for collecting data from all files in a specific folder.
The parts of the code that need to be edited are colored to draw your attention.
Last edited by JBeaucaire; 12-26-2019 at 04:10 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks