Excel: Copy data from one workbook to another

  Gary Wood 14:08 14 Jan 2009

I have an Excel file that contains several columns and about 2000 rows of data.

I want to create copy of this workbook that has some additional columns. However, I want the columns that are the same as the first workbook to update automatically when any changes are made to workbook 1.

I know I could do this by putting a forumla in every cell of the second workbook to make it the same as the corresponding cell in the first workbook, but I wondered if there's a quicker/better way to set certain columns to always match the first book?

Thanks in advance, if anyone can help.


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?