G
G-man
Hi,
Lets say I have four Workbooks and the data is located as follows;
Worbook Tab Range
Data1 Sheet1 A1:B5
Data2 Sheet2 A1:B6
Data3 Sheet3 A1:B7
Master SheetA A1,A10,A15
I want the Master sheet to automatically get data from Data1, Data 2, and
Data3. Assume I can make the file path consistant. Should I use a macro?
What would the code be? Where is good place to figure out basic marcos?
Thanks,
Greg
Lets say I have four Workbooks and the data is located as follows;
Worbook Tab Range
Data1 Sheet1 A1:B5
Data2 Sheet2 A1:B6
Data3 Sheet3 A1:B7
Master SheetA A1,A10,A15
I want the Master sheet to automatically get data from Data1, Data 2, and
Data3. Assume I can make the file path consistant. Should I use a macro?
What would the code be? Where is good place to figure out basic marcos?
Thanks,
Greg