I have a number of spreadsheets (12) that feed a summary sheet. The 12 sheets derive their static information from the summary, e.g. item names, dates, etc. While data is input into the 12 sheets.

I am trying to create a macro that will add a row, for a new item, in all of the sheets. Once the row is added I need to copy the formula from the previous row. The added row is not the last row of the spreadsheet.

Thank you for your help.