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

Have a look here:
http://www.rondebruin.nl/copy7.htm

what
you are looking for ?


Corey....


"G-man" <G-(E-Mail Removed)> wrote in message
news:390903E1-EFF7-4356-9080-(E-Mail Removed)...
> 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
>