drop down symbol and a database attached to it

[Guest]

I type in customer name every week in to a new worksheet( some times customers are not same as previous week) into a column. I like to know if there is a way to add a drop down symbol to each cell and a database of cutomer names, so that i can select the name from th list, thank for the help

 

[Jim]

Data>Validation>Settings>Allow>List where you enter an equal sign and and a
named range containing customer names, such as =MyCustomers OR refer to the
range that holds the custimer names =M2:M100 OR list the names, each
sparated by a comma and no spaces such as: sanik,Jim, etc.


--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays

I type in customer name every week in to a new worksheet( some times

customers are not same as previous week) into a column. I like to know if
there is a way to add a drop down symbol to each cell and a database of
cutomer names, so that i can select the name from th list, thank for the
help

 

[Gord Dibben]

Sanik

You say "New Worksheet". Are you inserting the worksheet via
Insert>Worksheet?

If so, perhaps you could set up a sheet template with the drop-downs already
entered.

Open a new workbook.
Delete all but one sheet.
Enter a list of customer names in any column, say P1100(or as many customers
as you forsee). Name this range as MyList.
You could hide that column if you don't want to see it. Or you could enter it
on any sheet in your original workbook so you don't have to duplicate it.
Select a range of cells then Data>Validation>Allow>List.
Enter =MyList
Check "in cell dropdown" and "ignore blanks".
Save the workbook as Save As>File Type>Template(*.xlt)
Name it SHEET, Excel will add the .XLT
Save it to your XLSTART folder.

This now becomes the default worksheet when you Insert>Worksheet.

Click on any cell in your Validated range and an arrow will appear. Click
arrow to get your list to choose from.

Gord Dibben Excel MVP