Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro copy data from one file to another?
Hello,
I have two files in a network drive where file1 contain a pivot data that is generated (added data in the last column) each day. then I have to open file1 to copy the data for today and pasted into another file2 where I did all the calculation and graphing. I would like to create a macro where it will open or copy the last column (E1:E7) with data from file1 and paste it to the last column without data (O1:O7) in file2 in sheet data. Here are the sample of data from both files. File1: Sheet1 sheet A B C D E Alt WC 2/20/2008 2/21/2008 2/22/2008 1 100 20 22 15 230 13 14 14 300 11 11 16 430 1.3 1.2 2.5 450 1.1 21.5 11.6 500 1.0 3.1 1.4 File2: Data sheet A B M N O Alt WC 2/20/2008 2/21/2008 1 100 20 22 230 13 14 300 11 11 430 1.3 1.2 450 1.1 21.5 500 1.0 3.1 NOTE: column C to L have existing data from file 2. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data for match word from one file to another file | Excel Worksheet Functions | |||
Copy data from an HTML file and paste into excel using a macro | Excel Programming | |||
recrding macro,copy data thn close file, get messge abut clpbord | Excel Discussion (Misc queries) | |||
macro to autofilter other file and copy in opened file | Excel Programming | |||
VBA Macro to copy an column from one Excel file into another file | Excel Programming |