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.

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

"Smith" <[email protected]> wrote in message
news:[email protected]...
>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
>
>