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.