Hello,
I would like a macro that would take the values from one column on one worksheet (Today) and sum them to another column on a different worksheet (Totals). The simplified version of what I'm looking for is something like this:
Range("Totals!C3").Value = Range("Totals!C3") + Range("Today!C3")
But instead doing this for just two cells, the macro would do this for over a hundred cells in one column. I have no idea how to do this besides copying and pasting the above formula for each row but I figure there must be a code that would automate that process for me and be much simpler to manipulate.
Bookmarks