Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inserting a row
I would like to have the user be able to insert a row depending on ho
many revenue categories there are for a particular company Revenue Revenue #1 Revenue #2 Total Revenue (sum Rev1 & Rev2) If there were three Revenue sources I would like to have a button tha would allow "Revenue #3" to be inserted and the "sum" formula change a well. Any suggestions?? Thanks -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
inserting a row
Instead of this sum formula:
=SUM(A1:A2). use =SUM(A1:INDEX(A:A,ROW()-1)) then, when the user inserts a row it won't matter, because the formula refers to THE ROW ABOVE IT. "bforster1 " wrote: I would like to have the user be able to insert a row depending on how many revenue categories there are for a particular company Revenue Revenue #1 Revenue #2 Total Revenue (sum Rev1 & Rev2) If there were three Revenue sources I would like to have a button that would allow "Revenue #3" to be inserted and the "sum" formula change as well. Any suggestions?? Thanks. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting row | Excel Discussion (Misc queries) | |||
Inserting? | Excel Discussion (Misc queries) | |||
Inserting row | Excel Discussion (Misc queries) | |||
Inserting zero | Excel Discussion (Misc queries) | |||
Inserting a row | Excel Programming |