Is it possible to Add Columns into the Middle of Existing Linked Data?

[mitylene]

Is it possible to Add Columns into the Middle of Existing Linked Data?[Solved]

I have just completed several workbooks. They are usable, but now we realize we needed more data than we currently have. Several of the workbooks are populating data from each other. Is it possible to add additional columns into the middle of the existing linked data without messing all the links up?

For example, the Factory Sales Order. They want to add a three digit customer ID into the beginning of the Sales Order worksheet, but that would mess up all the workbooks pulling the Quantity Shipped.

Any help would be very much appreciated.

Thanks,

Thank you!

[Richard Buttrey]

Hi,

If both workbooks are open in memory you should not have any problems adding columns. The range references will adjust automatically.

Rgds

[mitylene]

So I just open both workbooks at the same time while I make the edits right?

Thanks

Hi,

If both workbooks are open in memory you should not have any problems adding columns. The range references will adjust automatically.

Rgds

[Lizabeta]

My genius contribution for the day:

Do a Save As first and make yourself a backup copy in case something goes wonky.

Murphy's Law says if you make yourself a back up copy, everything will be Shiny.

If you don't... Things Don't Go Smooth.