| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding rows in between formulas
I have a worksheet that has blank rows between formulas. For example:
4 Club 1 5 Mary $15.00 6 Deb $15.00 7 total $30.00 8 9 Club 2 Karen $15.00 10 Tim $15.00 11 total $30.00 Each dollar amount column has a formula. If I want to add a row "total" and "karen" what do I do to keep the formula for the correct row number. Someone did something on the spreadsheet and the row numbers do not match up with the formula. There approximately 200 "Clubs". Is there an easy and fast way to carry the formula through to each "club" without filling in the blank lines with formulas? Is this as clear as mud??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding five new rows every 40 rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
| adding rows | Excel Discussion (Misc queries) | |||
| Rows containing "#N/A" are messing with my formulas, please help | Excel Worksheet Functions | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
| Adding rows to an array | Excel Worksheet Functions | |||
Threaded Mode
