G
Grip
I have an Excel Workbook with 2 worksheets. One is lable A and the other one
is B.
In each worksheet there is a several columns A - L. In the first two
columns of each work sheet is two columns on with a date and one with a time.
Typically it will say Column A2 = 1/27/08 and B2: 1115. What I would like
to do is take the date and time from worksheet A then look on Worksheet B for
the same Date and time match and then copy the entire row from B to the
correct matching row on A.
So essentially I will have a row that has matching data from each table
combined to 1 worksheet so all data is lined up. This WorkSheet B data
should append to Column M with the rest lining up in order to the right.
Additionally, If there is no matching data it will just be a blank on the
row from column M right.
Thanks for any help. I looked this up and cannot find a solution.
is B.
In each worksheet there is a several columns A - L. In the first two
columns of each work sheet is two columns on with a date and one with a time.
Typically it will say Column A2 = 1/27/08 and B2: 1115. What I would like
to do is take the date and time from worksheet A then look on Worksheet B for
the same Date and time match and then copy the entire row from B to the
correct matching row on A.
So essentially I will have a row that has matching data from each table
combined to 1 worksheet so all data is lined up. This WorkSheet B data
should append to Column M with the rest lining up in order to the right.
Additionally, If there is no matching data it will just be a blank on the
row from column M right.
Thanks for any help. I looked this up and cannot find a solution.