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!
Bookmarks