Formula for inserting or deleting rows

%3CLINGO-SUB%20id%3D%22lingo-sub-1803768%22%20slang%3D%22en-US%22%3EFormula%20for%20inserting%20or%20deleting%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1803768%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Developers%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20Excel%20on%20regular%20basis%20and%20to%20save%20time%2C%20wanting%20to%20automate%20few%20of%20my%20processes.%3C%2FP%3E%3CP%3EAs%20a%20part%20of%20this%2C%20i%20have%202%20excel%20sheets%20with%20same%20data%20-%20one%20for%20internal%20with%20more%20elaborate%20details%20and%20other%20with%20few%20columns%20not%20included%2C%20but%20No.%20of%20rows%20remain%20the%20same.%3C%2FP%3E%3CP%3ESo%2C%20would%20be%20helpful%20if%20there%20was%20a%20formula%20for%20inserting%20rows%20in%202nd%20sheets%20when%20details%20are%20filled%20in%201st%20sheet.%3C%2FP%3E%3CP%3EFormula%20example%20as%20below%3A%3C%2FP%3E%3CP%3E%3DINSERTROW(G5%26gt%3B0%2CSheet2!G5)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20per%20the%20formula%2C%20if%20there%20is%20value%20or%20text%20in%20G5%20of%20Sheet1%2C%20then%20a%20new%20row%20will%20be%20inserted%20in%20Sheet2%20-%20row%205.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20know%20if%20similar%20is%20possible%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1803768%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
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