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