Excel Linked Workbook with static columns

[jwehrly2000]

Hello all, I have created a workbook that inputs data from a different workbook via external links for columns A through F. I also have input data with no links in columns G through I. I need to constantly update the linked worksheet which could remove or add rows of records. I need a way to keep all of the data in each row so when the linked table is updated the records stay intact.

Please help if possible, if more info is needed please let me know.


V/r

Jeremy