Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Match as well as does not match array function | Excel Discussion (Misc queries) | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |