Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
matching
I have 2 separate workbooks that I want to place into a 3rd workbook.
The first and second workbooks looks very similar to this: 1st workbook FDP 4.5 TAX 2 FDP 49.95 FDC FRG 10 FRG LOC 5 LTC MOV 269.82 MPV ROM 930.6 TAX 2 ROM 10385.65 RME ROM 240 UPG TEL 17.99 LDC 2nd workbook FDP 54.45 GLD FRG 10 GLD LOC 5 GLD MOV 269.82 GLD ROM 11556.25 GLD TEL 17.99 GLD As you can see I have the possibility of double entries in the first column. The 3rd worksheet has columns for each day of the month with tabs for all the items in the first column. What I need it to be able to place these 2 workbooks into the third workbook in the correct column in the correct tab and matching the codes in the 3rd column. The codes used in the 3rd column on the first 2 workbooks match the first column in the 3rd workbook. I was hoping to use some kind of match/vlookup place all the items in the correct column. In the workbook that has the macro in it, it will contain the correct date using =Now(). Thanks in advance for the help. -Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help me to first row matching First date and last row matching lastrow | Excel Programming | |||
Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
Matching rows in 2 sheets and copying matching rows from sheet 1 t | Excel Programming | |||
Matching data and linking it to the matching cell | Links and Linking in Excel |