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:

=INSERTROW(G5>0,Sheet2!G5)

 

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