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

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