Macro to Synchronize data frm svrl workbooks & columns to 1 workbo
 

I am trying to record a macro that will pull from several different
workbooks with active data. For Example: I want to take the data in
workbook1 column "A" and copy and paste it to column "A" in workbook3, then
look at workbook2 and copy and paste the data in column "A" to the first
open cell in workbook3 column "A". It then needs to do the same thing for
column "B" & "C". The data in workbooks 1 & 2 columns "A", "B" & "C" will
be changing daily.
The problem I run into when I try to record this macro is that I need for it
to look in the entire column "A" for any additions and copy all data and
paste it into Column "A" then it needs to look in the entire column "B" and
paste in column "B" where the last piece of data in column "B" from
workbook1 stopped. When I have tried to record in the past it will copy all
of column "A" in workbook1 but when it copies all of "A" in workbook2 it
only recognizes where I told it to start previously so it essentially copies
over all of the "new" data from column "A" in workbook1.

Any help or guidance would be appreciated.


Thanks

Judd

What exactly s it that you are trying to achieve here. Is it that you want
to copy on the first day from say rows 1 to 10 in workbook 1, say values from
1 - 10, then rows 1-5 in Workbook 2 - say values are a-e. Your values in the
rows will then be 1,2,3,4,5,6,7,8,9,10,a,b,c,d,e.

The next day you want to copy rows 11-15 in Workbook 1, and say rows 6-8 in
Workbook 2, so that your data looks as follows:
1,2,3,4,5,6,7,8,9,10,a,b,c,d,e,11,12,13,14,15,f,g, h.

Or do you want to copy the entire column ever day, so that your data on day
2 will be: 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,a,b,c,d,e,f,g, h.

Let us know


"jbsand1001" wrote:

I am trying to record a macro that will pull from several different
workbooks with active data. For Example: I want to take the data in
workbook1 column "A" and copy and paste it to column "A" in workbook3, then
look at workbook2 and copy and paste the data in column "A" to the first
open cell in workbook3 column "A". It then needs to do the same thing for
column "B" & "C". The data in workbooks 1 & 2 columns "A", "B" & "C" will
be changing daily.
The problem I run into when I try to record this macro is that I need for it
to look in the entire column "A" for any additions and copy all data and
paste it into Column "A" then it needs to look in the entire column "B" and
paste in column "B" where the last piece of data in column "B" from
workbook1 stopped. When I have tried to record in the past it will copy all
of column "A" in workbook1 but when it copies all of "A" in workbook2 it
only recognizes where I told it to start previously so it essentially copies
over all of the "new" data from column "A" in workbook1.

Any help or guidance would be appreciated.


Thanks

Judd