Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking worksheets | Excel Worksheet Functions | |||
Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
linking worksheets in same workbook | Excel Discussion (Misc queries) | |||
Linking to Worksheets on Excel -Saved Web Page | Links and Linking in Excel | |||
Simplify Linking to several worksheets?? | Excel Worksheet Functions |