Import data and update records

[siroco79]

Hi there,

This may be a bit complicated, but basically I would like to frequently update a worksheet by importing a csv file that matches with my current columns and rows structure and will contain new data = additional rows (this is not a problem), but also existing data that should be updated (replacing old value for the new one).

I am not pretty sure whether this is possible or not, if it is; it should def hlookup or match existing values in my rows and then don't know how to, but replacing all new values (in columns) for the old ones.

This is an introduction to the problem, I would start sharing with you guys more requirements of background whenever you need it, as I am not sure whether this is feasible with Excel?

THanks a lot for your input!

[siroco79]

Hi,

Any ideas? Thanks a lot for any single suggestion.

All the best,

[ChemistB]

Sounds like something you could do with VBA. Import the data into a blank tab, run the VBA which updates existing data and adds new data. Unfortunately, VBA is not my forte.

[siroco79]

Thanks Chemist!

So think it is possible. Do you think it could be done with formulas? I have tried different approaches but none would make it. I would rather prefer to use formulas instead of, but if no way then VBA will be fine, I guess...

Eitherway, is there any forum user that could give me a hand with VBA to achieve this?

Thanks!!

[ragulduy]

so after the import you would have additional data at the end of a table, some of which would be duplicates of data earlier in the table and you would want the data closest to the bottom of the table to overwrite the duplicates which are higher up the table? If so, you could something like:

Please Login or Register  to view this content.

Assuming your unique ID's would be in column A.

If you could upload a workbook with an example of your data after the import I could post a less generalised solution.

With a formula you would need a blank worksheet with a formula to pick up the last unique row in, then copy and paste the values over top top of the original sheet. Again, it would be useful with a workbook to develop the formula in.

[siroco79]

Hey, thanks a lot for it!

You really understood what I meant. I will share with you in a few days an example of it!

Cheers!