Automatically populate formulas when a new row is inserted
I have a worksheet that staff will enter data into each week. It is highly
likely that they will need to insert addional rows. The formulas from the above row will need to be populated into the inserted rows and the rows below will need to refer to the new inserted rows. Otherwise the entire spreadsheet will fail. The formulas are in two columns which will be hidden from view and the worksheet locked. Is there a way that allows these two formulas to automatically be popluated into the respective cells when an employee inserts a new row? |
All times are GMT +1. The time now is 12:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com