|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 17th, 2005, 08:01 PM
|
|||
|
|||
Linking worksheets
I have two worksheets in a workbook to store data about my CD collection;
one is alphabetical and one chronological (based on purchase date). How do I link the sheets so that when I enter data about additions to the collection in the chronological sheet the alphabetical sheet automatically updates? Any help appreciated. TIA Tony Smith 
|
|
#2
March 18th, 2005, 07:17 AM
|
|||
|
|||
|
Hi Tony
Maintaining two sheets is not a sensible approach. Why not just have one sheet and sort it either alphabetically or chronologically depending on which view you want at the time? Data / Sort will do the sorting for you Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| linking info across worksheets within single workbook | Lynda | New Users | 1 | October 25th, 2004 08:53 PM |
| drop down box linking worksheets | justinjamesaaron1 | General Discussion | 1 | July 14th, 2004 12:32 AM |
| Linking Worksheets | Doug | Worksheet Functions | 0 | February 17th, 2004 07:21 PM |
| Linking contents of Worksheets | PLN | Worksheet Functions | 2 | February 13th, 2004 05:49 PM |
| Automatic linking of cell data between worksheets | CherylB | Worksheet Functions | 0 | December 10th, 2003 05:58 PM |
Linear Mode
