thewiseguy
Well-known Member
- Joined
- May 23, 2005
- Messages
- 956
- Office Version
- 365
- Platform
- Windows
Hi all,
My workbook (workbook1) has a master worksheet with a large table of data; let's call this 'Table1.'
Table1 contains products we sell, and each product has roughly 25 columns worth of data which correspond to those products.
As time goes on, we add products, so if i open an old workbook, there are many times that I need to enter (again) the new products along with the 25 columns worth of corresponding data.
Table1 is filled with validation lists and range references all within workbook1.
Is there a way to copy and paste NEW table data into an older version without changing all of the cell references? I want to be able to keep whichever workbook I am pasting into - I want to keep those cell and data references, b/c they all remain the same as time goes on.
Any help is appreciated!
My workbook (workbook1) has a master worksheet with a large table of data; let's call this 'Table1.'
Table1 contains products we sell, and each product has roughly 25 columns worth of data which correspond to those products.
As time goes on, we add products, so if i open an old workbook, there are many times that I need to enter (again) the new products along with the 25 columns worth of corresponding data.
Table1 is filled with validation lists and range references all within workbook1.
Is there a way to copy and paste NEW table data into an older version without changing all of the cell references? I want to be able to keep whichever workbook I am pasting into - I want to keep those cell and data references, b/c they all remain the same as time goes on.
Any help is appreciated!