B
bgardiner
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
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