Hi,
I am working on a spreadsheet (call it "A"), with eight different columns. Four of which (the first four) will have feeded information from a seprate spreadsheet ("B"). The next four columns will contain information which will be inputted mannually.
The problem i'm having, is that when I add a row to spreadsheet B, the information on the first four columns on spreadsheet A will move down accrodingly, but the mannual information I inserted in the last four columns, will stay in the same row they were inserted.
How can I do it, so that when I add or delete a row in spreadsheet B, the mannual information on spreadsheet A, will move in sync with the first four columns? Hope this makes sense.
Kr,
Clint
Bookmarks