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

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone