Insert rows on sheet as rows on master sheet are filled in

This might be a macro question, so my apologies if this got posted to the wrong forum.

Basically I have a workbook with several sheets. Sheet 1 is the master data-entry sheet. The other sheets contain columns of data that run formulas on the data in the master sheet.

When I add a new row to the master sheet, I would like the other sheets to automatically insert a new row and copy the relevant formulas from the row directly above.

So if I fill in data in the cell A2 of the Master sheet, I would like SubSheet1 to automatically insert row 2 and copy all of my formulas down from row 1. Hopefully that explanation makes sense.

TIA!

Hi Dunc3142,

Thanks for the file - that definitely fits the bill from the end-user perspective. I'll need to complicate this a little bit further.

I ultimately "Save As" the SubSheets as .csv files to be imported into a system that can only parse .csv. When I SaveAs, the resulting .csv has good data for the rows that have been filled in. But for the blank rows, the .csv file shows ",,,,,,,,,,,," (etc).

These "blank rows" contain the IF formulas that control whether data is populated or if the cell is left blank (=""). Any ideas on how to arrive at a .csv file that does not contain these "blank" rows? Are we getting more into Macros now?

Thanks!

Hi Dunc3142,

Thanks for the file - that definitely fits the bill from the end-user perspective. I'll need to complicate this a little bit further.

I ultimately "Save As" the SubSheets as .csv files to be imported into a system that can only parse .csv. When I SaveAs, the resulting .csv has good data for the rows that have been filled in. But for the blank rows, the .csv file shows ",,,,,,,,,,,," (etc).

These "blank rows" contain the IF formulas that control whether data is populated or if the cell is left blank (=""). Any ideas on how to arrive at a .csv file that does not contain these "blank" rows? Are we getting more into Macros now?

Thanks!