Rock on!

U DA MAN!


Would you agree, however, that ACCESS would be a better choice for this?
--
Jeff


"Pete_UK" wrote:

Jeff,

Here's a link to a post I answered a few days ago which is similar to
yours:

http://groups.google.com/group/micro...3d37affa313?q=

Perhaps you can adapt the suggestions there to your situation -
essentially, make a unique linked reference for each record in a
helper column (based on name), and then use that to bring multiple
records together on another sheet.

Hope this helps.

Pete

On Dec 15, 7:56 pm, Jeff wrote:
Yes!

More than one record for an employee and there is no unique number.
--
Jeff



"Pete_UK" wrote:
Are you implying that you might have more than one record for an
employee? Is the ID# unique - it would be better to use this rather
than name to specify who you want to find.

Pete

On Dec 15, 7:24 pm, Jeff wrote:
I have inherited a HUGE spreadsheet that probably needs to be converted to an
Access Database.

However, I have been tasked with making the info retrievable in its present
format.

Please give me suggestion for the following scenario:

10 columns/labels: Employee, Name, location, id#, Rating, etc.

2500 rows or records.

I would like to enter the employee name on a separated spreadsheet, and have
all of that employees records, or rows, displayed.

Thank you!!

Jeff

--
Jeff- Hide quoted text -

- Show quoted text -