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?