Data shifting

Brass 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