V
Vanessa
Hi! I've been trying to figure this out for a while, and I just can't
seem to come up with anything even close to right. I receive a list
every morning and need to compare it to the list I received yesterday,
copying over the additional data I entered on yesterday's list for all
those who are still on today's list. So I have two excel worksheets
("today" and "yesterday") and I need a macro that will compare a range
of cells on "yesterday" to "today" and copy data from the same row in
"yesterday" to the matched column in "today". (The lists are actually
in two separate workbooks, but I was trying to do this after copying
them into different sheets in the same workbook because I thought that
would be easier for me to write the macro.)
Here's an illustration:
Yesterday's list:
Column A Column B Column C Column R Column S Column T
Column U Column V
Last1 First1 DOB1 ………….. R1 S1
T1 U1 V1
Last2 First2 DOB2 ………….. R2 S2
T2 U2 V2
Last3 First3 DOB3 ………….. R3 S3
T3 U3 V3
Last4 First4 DOB4 ………….. R4 S4
T4 U4 V4
Last5 First5 DOB5 ………….. R5 S5
T5 U5 V5
Last6 First6 DOB6 ………….. R6 S6
T6 U6 V6
Last7 First7 DOB7 ………….. R7 S7
T7 U7 V7
Last8 First8 DOB8 ………….. R8 S8
T8 U8 V8
Today's list:
Column A Column B Column C Column R Column S Column T
Column U Column V
LastA FirstA DOBA
LastB FirstB DOBB
Last1 First1 DOB1
LastC FirstC DOBC
LastD FirstD DOBD
Last8 First8 DOB8
LastE FirstE DOBE
LastF FirstF DOBF
Today's list as I want it after macro:
Column A Column B Column C Column R Column S Column T
Column U Column V
LastA FirstA DOBA
LastB FirstB DOBB
Last1 First1 DOB1 ………….. R1 S1
T1 U1 V1
LastC FirstC DOBC
LastD FirstD DOBD
Last8 First8 DOB8 ………….. R8 S8
T8 U8 V8
LastE FirstE DOBE
LastF FirstF DOBF
I have really spent a lot of time working on this, but I don't
understand enough about VBA to make it work. Any solutions or advice
would be MUCH appreciated!!! It will save me so much time every
morning if I don't have to do this manually. Please let me know if I
haven't explained something clearly--I'm happy to try to clarify
further.
Thank you!
Vanessa
seem to come up with anything even close to right. I receive a list
every morning and need to compare it to the list I received yesterday,
copying over the additional data I entered on yesterday's list for all
those who are still on today's list. So I have two excel worksheets
("today" and "yesterday") and I need a macro that will compare a range
of cells on "yesterday" to "today" and copy data from the same row in
"yesterday" to the matched column in "today". (The lists are actually
in two separate workbooks, but I was trying to do this after copying
them into different sheets in the same workbook because I thought that
would be easier for me to write the macro.)
Here's an illustration:
Yesterday's list:
Column A Column B Column C Column R Column S Column T
Column U Column V
Last1 First1 DOB1 ………….. R1 S1
T1 U1 V1
Last2 First2 DOB2 ………….. R2 S2
T2 U2 V2
Last3 First3 DOB3 ………….. R3 S3
T3 U3 V3
Last4 First4 DOB4 ………….. R4 S4
T4 U4 V4
Last5 First5 DOB5 ………….. R5 S5
T5 U5 V5
Last6 First6 DOB6 ………….. R6 S6
T6 U6 V6
Last7 First7 DOB7 ………….. R7 S7
T7 U7 V7
Last8 First8 DOB8 ………….. R8 S8
T8 U8 V8
Today's list:
Column A Column B Column C Column R Column S Column T
Column U Column V
LastA FirstA DOBA
LastB FirstB DOBB
Last1 First1 DOB1
LastC FirstC DOBC
LastD FirstD DOBD
Last8 First8 DOB8
LastE FirstE DOBE
LastF FirstF DOBF
Today's list as I want it after macro:
Column A Column B Column C Column R Column S Column T
Column U Column V
LastA FirstA DOBA
LastB FirstB DOBB
Last1 First1 DOB1 ………….. R1 S1
T1 U1 V1
LastC FirstC DOBC
LastD FirstD DOBD
Last8 First8 DOB8 ………….. R8 S8
T8 U8 V8
LastE FirstE DOBE
LastF FirstF DOBF
I have really spent a lot of time working on this, but I don't
understand enough about VBA to make it work. Any solutions or advice
would be MUCH appreciated!!! It will save me so much time every
morning if I don't have to do this manually. Please let me know if I
haven't explained something clearly--I'm happy to try to clarify
further.
Thank you!
Vanessa