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

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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Smith" wrote in message
...
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