Hello David and Jonathan First I tried this with existing values. I put one paste link into the summary page from a working sheet cell. Then I copy down on the summary page by grabbing the bottom right square of the one cell where it copies the same value, instead of sequencing it. How do I get it to sequence without manually changing the paste link in each cell? When I have a linked reference in a cell Jonathan, how do I combine the "if statement" with the link? When I research zeros, it says to do this: 1. Select "Tools" - "Options". 2. When the "Options" multi-tabbed dialog box appears, select the "View" tab. 3. Underneath "Window options", uncheck "Zero values". 4. Click "OK" to save your changes. But I have Excel 2007, there is no Tools or Options, and the View tab has nothing about zeros. Gayle ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to share files with the group, you must join our Yahoo sister group. This group will not allow for posting of emails, but will allow you to join and share problem files, templates, etc.: http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE SHARING ONLY. If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm *************************************************************