How to create an Excel row drop down

[moes123]

Hello,

I have a spreadsheet with all my users whom have a blackberry phone, this sheet has six (6) columns with various details of the phone and rows with the user names, i want to create a dropdown to show the previous phone so i can simply click the little + button to drop the list showing previous phones the user had, an e.g. is:

Name Model serial #
Moes 8900 Curve 958485023117842 (N.B. current phone)
Moes 8520 Bold 458485023147852 (previous phone)
Stacy 8900 Curve 445485023147850 (another user)

The list would continue going down with other user names, therefore i don't want to keep duplicating a user name to show other records of previous phone data, the name should only be in one record, the current record should only show, only to view previous phones the + button can be clicked dropping down the list.

Thanks in advance

moes.

 

[Gavona]

How about using grouping and outlining to hide previous phones? Would need the current phone to be the last in your list.

Alternatively you have to create a data validation list for each user. Can users have more than one previous phone? If not then this could be done relatively easily using Insert,Names,Create....But how often does your list get updated? How big is it?



Gavin

 

[lionelhill]

Just a thought, but probably not very helpful. If the serial number data contains only unique values, and new phones always have higher serial numbers than old, you could consider a pivot table reporting the maximum serial number. How you'd get the associated other data, I don't know.

 

[SkipVought]

This is something that I do occasionally.

I have summary data on sheet1 and detail data on sheet2.

Select a cell in the summary data one Sheet1 and an event-driven procedure filters the detail data on Sheet2 accordingly and activates Sheet2 for viewing.

How does that process strike you?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}