Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare values between workbooks and copy values
Hello,
I download a file called datamanager.csv that I need to update with information from combined.csv on a weekly basis. I compare the cells in column E (System Name) in combined.csv with the cells in column V (serial) in datamanager.csv and when I find a match, I copy that row of information. So if E2 in combined.csv = V6 in datamanager then I would copy combined.csv!A2 (city) to datamanager.csv!J6 (city), combined.csv!B2 (state) to datamanager.csv!K6 (state), combined.csv!C2 (location) to datamanager.csv!L6 (location), combined.csv!F2 (code) to datamanager.csv!M6 (code), combined.csv!G2 (type) to datamanager.csv!N6 (type), and combined.csv!I2 (num) to datamanager.csv!O6 (num) When a match is found I always want the cell in datamanager.csv to be overwritten with the information from combined.csv. If a match isn't found then I want the fields in datamanager.csv to be left alone. What are your suggestions? Thank you for your help. Brad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare Values in A and Copy to B | Excel Discussion (Misc queries) | |||
how do you use vlookup to compare values between two workbooks | Excel Worksheet Functions | |||
Compare and copy unique values | Excel Worksheet Functions | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) |