Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a master.csv (source) and myrpt.xls (destination)file, I need to match
the acct#. 1) if acct# match update the amount (total column) 2) if acct# don't match insert new data (Account, State & Total) from master to myrpt to next blank row. Master.csv A B D E F ACCOUNT State PAST_60 PAST_90 TOTAL 11-12792 CA 225.15 886.44 1,111.59 11-25851 ME 591.94 130.80 722.74 11-32239 AZ - 2,676.00 2,676.00 11-34849 AR 1,350.00 900.00 2,250.00 11-35239 ID 135.67 134.42 270.09 11-40015 CO 106.75 353.74 460.49 myrpt.xls (sheet1) A B C ACCOUNT State TOTAL 11-25851 ME 650.74 11-35239 ID 150.00 Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
INDEX/MATCH update limitation | New Users to Excel | |||
How to insert a row and not update existing formulas? | Excel Discussion (Misc queries) | |||
Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
Update of cell values after insert row? | Excel Worksheet Functions | |||
insert into a cell the last update | Excel Worksheet Functions |