how to find last value in a column, and replace data

[abagga]

Hi,

In the attached file "UH data", I want to go to last date (11/17/2020) and do vlookup of this date with date in "Med" file and copy all data from "Med" after that date. This data (after data 11/17/2020 in this case) will replace existing data in UH data file. Both columns (date and amount) needs to be replaced.

[Qiu]

@abagga 
something like this?

[abagga]

Not really. All values after date 11/17/2020 in file Med should be copied to UH date file and replace existing data in it. Hope this clarifies. Thank you!

[Qiu]

@abagga 
Sorry, seems I did it the other way around.

[abagga]

Does it also deletes existing data in UH data completely. I want that to happen

[AngelosPachis]

Hi @abagga ,

Would something like this work for you?

I have added the output tool in a container box, but essentially once you activate it it will overwrite the data in the UH input file.

Hope that helps,

Regards,

Angelos