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