Linking sheets

[Smith]

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

 

[Earl Kiosterud]

Tony,

Normally, you keep them in one table, and just sort on the column you're
interested in at any time (name, purchase date, etc.). Be careful with
sorting in Excel, though.