Macro to calculate YTD & replace cell content

Microsoft Excel 2007
June 10, 2010 at 09:48:25
Specs: Windows Vista
I have an Excel spreadsheet. It has 3 columns: Unit Number, Month, YTD. I would like a macro that will add the month total to the YTD total, then replace the contents of the YTD cell w/ the updated YTD.

I'm new to macros and have searched high and low for this (it seems fairly simple to me), but I've had no luck.

Any help out there?

Thx!!


See More: Macro to calculate YTD & replace cell content

Report •


#1
June 10, 2010 at 12:13:49
re: add the month total to the YTD total

How is the "month total" getting into the cell...or is it cells?

Please explain the layout of your sheet a little further.


Report •
Related Solutions


Ask Question