--------------------------------------------------------------------------------

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=494037

First, I don't have any code to do this.

Second, I wouldn't do it if I did. I think you'll find it easier to put your
data in one file and use links to that master file in other files. When you put
your data in multiple spots, something will go wrong and you'll be out of sync
before you can realize it.

Just my opinion, though.

ashcrusher wrote:

--------------------------------------------------------------------------------

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=494037

--

Dave Peterson