Thanks for the advice I will look into that option. I had tried to use that earlier but I must not have set it up correctly as when I inserted a row in the additinal column for that row the data did not move with the rest of the row. I will look at your link and try it again.
HI,
I am having some issue with linking workbooks. The source workbook has rows, inserted, modified and deleted. The desitination workbook as columns added and when they are linked to source without adding data (which breaks the link) they are ok but if you add data and then insert a row...