Update existing file- Add (Sum) the data when new data come in daily

[bleu]

I'm sure there's a simple solution but I can't figure it out.

- Only one file exists

- When new data comes from in the database read the file and add the data to the correct columns

- Output the new data (with the totals) to the same spreadsheet (overwrite it daily)

I don't know how to add the data to existing data. I don't want to append it. I want it added.

Any advice would help!

Thank you

[binuacs · Accepted solution]

@bleu 

[bleu]

OK. I've got 50+ columns so I'll just have to make sure all the field names match up every single time or my results will be off when I use the Record ID.

Thank you Quasar! This will work.