Data shifting

%3CLINGO-SUB%20id%3D%22lingo-sub-2220714%22%20slang%3D%22en-US%22%3EData%20shifting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2220714%22%20slang%3D%22en-US%22%3E%3CP%3EAttached%20is%20the%20downloaded%20file%20from%20Google%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EValues%20in%20%22Open%22%20sheet%20auto%20updates%20when%20we%20add%20values%20%22Facebook%22%20sheet%20in%20column%20A%20to%20F.%20And%20the%20values%20from%20column%20G%20to%20J%20needs%20to%20be%20entered%20manually.%20What%20I%20need%20is%20that%20when%20something%20is%20added%20in%20%22Facebook%22%20sheet%20and%20when%20it%20gets%20updated%20in%20%22Open%22%20sheet%20then%20values%20already%20present%20(i.e.%20in%20row%204%20and%205%20in%20present%20case)%20in%20%22Open%22%20sheet%20needs%20to%20be%20shifted%20to%20below.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20be%20more%20clarified%20if%20anything%20is%20added%20in%20row%204%20in%20column%20A%20to%20F%2C%20then%20cell%20G4%20to%20J5%20should%20be%20moved%20one%20down%20to%20cell%20G5%20to%20J6.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGet%20in%20touch%20if%20still%20this%20is%20not%20cleared.%20Any%20solution%20is%20HIGHLY%20highly%20welcomed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2220714%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Attached is the downloaded file from Google sheet.

 

Values in "Open" sheet auto updates when we add values "Facebook" sheet in column A to F. And the values from column G to J needs to be entered manually. What I need is that when something is added in "Facebook" sheet and when it gets updated in "Open" sheet then values already present (i.e. in row 4 and 5 in present case) in "Open" sheet needs to be shifted to below. 

 

To be more clarified if anything is added in row 4 in column A to F, then cell G4 to J5 should be moved one down to cell G5 to J6.

 

Get in touch if still this is not cleared. Any solution is HIGHLY highly welcomed.

0 Replies