Need Excel / Database Help

[.Kencs]

My dad does HAM Radio, and records who he speaks to and from where in the world, so far he has about 2,000+ records in Excel, and he wants to be able to put a call sign in, for example, AB123 and it will list when he spoke to that person, is there a way I can make it easy for him to use? He isn't very good with excel lol...

Thanks

 

[Mel_P]

Use "Filter" by selection on call sign column?

 

[Sin_Chase]

Yup, put a filter on all the data (just select every column number assuming this is column separated headings with row by row data and whack the Filter button). Go to call sign column, open filter with the drop arrow, deselect "Select All" and find/select the one he wants to view.

MS blurb:
http://office.microsoft.com/en-us/excel-help/filter-data-in-a-range-or-table-HP010073941.aspx