Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Macro: summing together/roll over rows (Energy Trading, see example)
(I attached the file so it will make more sense.) Basically what I need is a macro that by clicking it will sum cell C12 and F12 placing the sum in F12, C13 and F13 placing the sum in F13, and so on. I need it to do this on a row by row basis. Each row basically represents a different product. Also, I would like a message to pop up when the macro is hit to ask "are you sure" Then by clicking yes or no it will do so accordingly. I've tried programming it in VBA using =sum with no luck. I would greatly appreciate any and all help. Thanks! +-------------------------------------------------------------------+ |Filename: excelforum example.zip | |Download: http://www.excelforum.com/attachment.php?postid=3486 | +-------------------------------------------------------------------+ -- dstock ------------------------------------------------------------------------ dstock's Profile: http://www.excelforum.com/member.php...o&userid=24225 View this thread: http://www.excelforum.com/showthread...hreadid=378647 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to roll up columns or rows for summary purposes? | Excel Worksheet Functions | |||
How do you create roll-up rows in EXCEL? | Excel Worksheet Functions | |||
calculating energy costs per month | Excel Discussion (Misc queries) | |||
how to record macro to roll over monthly data | New Users to Excel | |||
how do i calculate energy consumed in excel? | Excel Discussion (Misc queries) |