Using a worksheet_change macro on sheet1 you can add formulas into sheet2.

"ssGuru" wrote:

I have a structured SS1 without any formulas. Header row and records.
I have a SS 2 that does all the calculations needed to report on SS1.
Its formulas point to SS1.

How can I have code automatically add formulas after the previous last
row in SS2 when a new record is added to SS1?

Currently I manually copy these IF THEN formulas for about 500 empty
records at a time in SS2 in preparation to receive new records in
SS1. They return "" if no values in SS1.

Is it possible to automate this process one record at a time?

Thanks for your feedback,
Dennis