I have a protected sheet in Excel 2003 which I have allowed access for users to Insert Rows into.
I have an IF formula in several of the rows "=IF(G54=0,"",G54/E54)" which I want to be automatically copied into the new row when the new row is inserted. However I dont want to have to unlock the cells where the formula is as users tend to shift the formulas around.
Advertise with us Editorial Contacts
With over 25 years of brand awareness and credibility, PCWorld Australia consistently delivers editorial excellence through award-winning content and trusted product reviews.
