Auto cut & paste

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Code for Pasting Sheets 2
Naming non-contigent cells with vba 5
Can we drag-copy cells from evry five row to every row 3
Search/Sort Formula Help Needed 4
Copy rows multiple times changing value of a cell in one column each time 1
Error 1004-application or object error 9
Copy Rows Multiple times "changing" values in one column 4
Get data from alternated cells 3

Top