Hi
You can either copy and paste the whole worksheet or paste individual cells. Follow these step:
1. Select all of the cells you want to link and then choose copy.
2. Move to the new Summary workbook and right click in the starting cell and choose "Paste Special".
Your cells will now contain a formula that links to the raw data. When the raw data changes the linked cells will change to reflect those changes.
Good luck.
Tony
Bookmarks