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

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 employee’s records, or rows, displayed.

Thank you!!

Jeff

--
Jeff

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

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 employee’s records, or rows, displayed.

Thank you!!

Jeff

--
Jeff- Hide quoted text -

- Show quoted text -

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 -

Thanks for the feedback, Jeff.

You described it as a HUGE database, but Excel comfortably handles
2,500 records - versions before XL2007 could manage 65,536 records in
each sheet - so why complicate it by using Access?

Pete

On Dec 16, 2:56*pm, Jeff wrote:
Rock on!

U DA MAN!

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

Jeff

Your data on sheet 1 colmna A - J

Enter a name in a1 of sheet 2
Put this in b1 of sheet 2 and drag right 9 columns

=VLOOKUP($A$1,Sheet1!$A$1:$J$2500,COLUMN(B1))

Mike

"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

Maybe a bit better

=IF($A$1="","",VLOOKUP($A$1,Sheet1!$A$1:$J$118,COL UMN(B1)))

Mike

"Mike H" wrote:

Jeff

Your data on sheet 1 colmna A - J

Enter a name in a1 of sheet 2
Put this in b1 of sheet 2 and drag right 9 columns

=VLOOKUP($A$1,Sheet1!$A$1:$J$2500,COLUMN(B1))

Mike

"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

And since the OP is matching on a name, I would think that he would want an
exact match.

=IF($A$1="","",VLOOKUP($A$1,Sheet1!$A$1:$J$118,COL UMN(B1),False))




Mike H wrote:

Maybe a bit better

=IF($A$1="","",VLOOKUP($A$1,Sheet1!$A$1:$J$118,COL UMN(B1)))

Mike

"Mike H" wrote:

Jeff

Your data on sheet 1 colmna A - J

Enter a name in a1 of sheet 2
Put this in b1 of sheet 2 and drag right 9 columns

=VLOOKUP($A$1,Sheet1!$A$1:$J$2500,COLUMN(B1))

Mike

"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

--

Dave Peterson