I need help with large data set

[Guest]

I have a 10 meg excel file with info on a 27 year long biology study.

Birds have been caught, tagged with a numbered banded, and data recorded.
Each row of data has date, banding number, length, widths, weights, notes,
etc.

What I am wanting to do is have it set-up where I can enter new data for
both new catches as well as the birds that have been recaptured.

Also, I want to be able to type in a band number and bring up all of the
historical data about that bird.

Although I have some ideas on how to do this, I don't know the best way to
do it.

Right now, I just have the data. Nothing else is set-up.

Any suggestions?

 

[Guest]

Hi, please do the following.
1. For each bird add a worksheet and rename it to the name of the bird.
1.1. Transfer the data from the original excel into this new one.
1.2. In the first row of each worksheet give titles to the columns, such as,
Date, Branding Number, etc....
2. To list the history of a particular branding number do the following,
2.1. Select the first row
2.2. Choose Data -> Filter -> Auto Filter from the File menu-bar
2.3. A dropdown icon will be listed in each of the column names
2.4. Click on the dropdown icon in the Branding Number column and choose the
required Branding Number