formula to follow when row inserted


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??
 
Ad

Advertisements

C

Cesar Zapata

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
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??
 

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

Top