Formula for inserting or deleting rows

Occasional Visitor

Hi Developers,


I use Excel on regular basis and to save time, wanting to automate few of my processes.

As a part of this, i have 2 excel sheets with same data - one for internal with more elaborate details and other with few columns not included, but No. of rows remain the same.

So, would be helpful if there was a formula for inserting rows in 2nd sheets when details are filled in 1st sheet.

Formula example as below:



As per the formula, if there is value or text in G5 of Sheet1, then a new row will be inserted in Sheet2 - row 5.


Please let know if similar is possible


0 Replies