I have one workbook (the master file) that I update biweekly with information I get from a report. In workbook 1, I have an ID number, description, and the current total. In workbook 2, I have the ID number, description (may vary from workbook 1) and the total for the period downloaded (anything that has occurred since the last download date).
When I say "current total" for workbook 1, it looks like this:
=5+95+108+52+34
or something to that nature. How can I add the new number from each new workbook 2 to the existing running total in workbook 1?
So if the new number for the above ID in workbook 2 is 68, it would look like
=5+95+108+52+34+68
Any help would be greatly appreciated!
Bookmarks