formula to follow when row inserted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two sheets, one with 190 rows of data, and the other with formulas for that data. I have one formula returning data for each row. Lets say I have a formula relating to the data in rows 4, 5, 6 etc., when I go to my data sheet and insert a row for new data, my formulas don't adjust for that inserted row. I am having to copy my first formula and paste it all the way down to get it to adjust to the new inserted row on my other sheet. If I copy 210 formulas down to compensate for any inserted rows on my other sheet, how do I get the formulas to automatically adjust??
 
You need a macro to do this.

Basically the easiest way is to turn on your macro recorder and record the
fill down of your formulas.


now if you have a user doing this you may wanna put a button that activates
the macro with the text "refresh". and tell them they need to click on it
after they have interseted some rows.


Cesar Zapata


Ben said:
I have two sheets, one with 190 rows of data, and the other with formulas
Click to expand...
for that data. I have one formula returning data for each row. Lets say I
have a formula relating to the data in rows 4, 5, 6 etc., when I go to my
data sheet and insert a row for new data, my formulas don't adjust for that
inserted row. I am having to copy my first formula and paste it all the way
down to get it to adjust to the new inserted row on my other sheet. If I
copy 210 formulas down to compensate for any inserted rows on my other
sheet, how do I get the formulas to automatically adjust??
 
Back
Top