Linked workbooks don't sync when new rows are inserted

[Phorbox]

Hello,

I would greatly appreciate your help - all the information concerning this subject was of no use so far..
I have 2 workbooks. Each contains 2 worksheets. Lets say first one is called "Master Workbook" and second one is "Source Workbook". There are around 17000 rows and a hundred columns in the Source Workbook.
Most of this information will be feeded into Master Workbook, with some additional columns that exist only in Master Workbook. The problem is - how do i preserve the information in those additional columns in Master Workbook when new rows are inserted in Source Workbook?..
To feed the information from Source to Master I've tried using the OFFSET function. It works fine with displaying new rows in Master Workbook when they are added in Source Workbook, except for the information in those additional columns in Master - the order in their rows is never preserved..
So basically my question is - how do i lock the rows in my Master Workbook when they have information from both Source Workbook and Master Workbook so that their order will not change when i add new rows to Source Workbook?..

Thanks.

[dilipandey]

Hi Phorbox,

Welcome to the forum.

The problem is - how do i preserve the information in those additional columns in Master Workbook when new rows are inserted in Source Workbook?..

those additional columns in master workbook are manual entry or what? I believe basis the information from source workbook we can formulate those additional data... e.g., if the word vegetable is what we are getting from source workbook... we can have onion, carrot etc based on formulas in master workbook itself....

Regards,
DILIPandey

<click on below 'star' if this helps>