How to correct formula error

Hi, Please find the attached spread sheet with example. I have given formula and it started from F3 in column F. This formula is linking with the values in the same row and the previous row. In this case in F3 is =E3*D2 and in F4 is =E4*D3. I have macro in G column which will add the rows and copy the data from this row to copied rows. When I add a row and copying the data using macro in G3 by selecting 1, 4th row seems to be ok in F4 (=E4*D3) but 5th row not seems to be ok in F5 (=E5*D3) because actually it should be =E5*D4. Can you help me how to correct this formula error?

Hello krish T,

Try,

Please Login or Register  to view this content.

Regards

Hello krish T,

Thank you for the feedback.

Please try the attached sample Workbook now.

Regards

Hello krish T,

You are welcome.

Glad I could help, and thank you for adding to my Reputation.

Regards