locked link
 

I am working on a spreadsheet with links. A value is placed in the
master sheet and is then linked back into the sub sheet. Everytime a
value is placed in master sheet, the sub sheet is updated. However, Im
trying to put a new column in the sub sheet, and make the master sheet
update this new column. However I want the old column to have the last
updated data before the new column was put in. How do i do this? and
does anyone have ne VB codes to achieve this?


--
ashcrusher
------------------------------------------------------------------------
ashcrusher's Profile: http://www.excelforum.com/member.php...o&userid=29681
View this thread: http://www.excelforum.com/showthread...hreadid=494021