Hello
I have a spreadsheet I use to record jobs my Dept works on.
One Worksheet shows totals from the current month.
At the end of every month I have to update it to show totals from following month.
Example: =SUM('ACME'!V48)
It's pretty simple as all I'm changing is the last two numbers within the above sum and all cells pull from the same row.
However... I have to change it in 4 places for each of 30 customers.
Any thoughts or direction would be most appreciated.
Thanks
Scotty
Bookmarks