inserting a row

  • Thread starter Thread starter bforster1
  • Start date Start date
B

bforster1

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spread Revenue Over Time - Excel Help 0
Create a yes no message on a command button on click 0
Autofilter using a value from a list. 2
How do I force a pivot column if there is no data? 5
Trailing 30 days sum calculation with excel 1
Custom Sort a Pivot Table (possibly w/ VBA?) 2
VBA for index match and an IF statement to make a cumbersome formula easier 2
Macro to add Multiple rows in same sheet 1

Back
Top