Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi guys!
After beating my head into the wall for the past hour, I though I'd come and ask the experts about the best way to solve my problem. I have a simple worksheet that looks like so: 15 15 15 30 15 45 15 60 15 75 The first column contains '15' and the second column does the formula =b1+a2, =b2+a3, and so on. The only row that isn't like this is the first row in which the formula is just =a1. My question is, how do I make it so that if I delete, say, the 3rd row, that my formulas will adjust automatically? I've attempted to play around with absolute references, but I still had problems when I deleted rows. Granted this is an extremely simple example, but hopefully, I'll be able to extend the solution to my very complex spreadsheet. Thanks, Rich |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to expand formulas to additional rows | Excel Discussion (Misc queries) | |||
Question regarding how to search a column and print a row(s) | Excel Discussion (Misc queries) | |||
Question regarding how to search a column and print a row(s) | Excel Worksheet Functions | |||
Copy/Insert rows with formulas | Excel Worksheet Functions | |||
Insert rows | Excel Worksheet Functions |