LinkBack URL
About LinkBacks
Hi Friends,
I have couple of rows with formula (e.g IF nested statements, VLOOKUP etc). But when the user insert a new row, these formulas are not copied automatically into the new row.
How can I have the formula copied into new row automatically
Hi Friends,
I have couple of rows with formula (e.g IF nested statements, VLOOKUP etc). But when the user insert a new row, these formulas are not copied automatically into the new row.
How can I have the formula copied into new row automatically
Convert the range to a Table. Highlight the data (including headers) and click Insert, Table, and check My Table Has Headers.
Thanks Jeff. This worked buddy!!
Glad to hear it! Thanks for the rep!
Hi Jeff, the following solution provided by you worked, but when I protect the sheet, it does not work.
"Convert the range to a Table. Highlight the data (including headers) and click Insert, Table, and check My Table Has Headers."
Kindly advice how can I make this solution work when the sheet is protected.
Select the table - right click - format cells - protection - make sure that the locked box is unticked (unchecked).
Now, when you pritect the sheet, make sure that you tick insert rows.
Now it should work OK when the sheet is protected.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi Ali,
I did the same as advised by you, but still the formula do not copied down atomically. In the screenshot , I inserted a new row 8 and I have formula in Col A and Col T. So cell A8 and T8 shod have formula copied down. But it is not working after I protect the sheet.
Attachment 620321
Out of ideas - sorry.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks