Excel: Copy data from one workbook to another

  Gary Wood 14:08 14 Jan 09

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.

AMD Ryzen release date, specifications and features: Three CPUs from the Ryzen 7 range now…

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…