create list to enter data in cell
Just an added note.
Excel has this built-in if you already have a list of items in a colulmn.
Right-click on the cell and "Pick from list"
You will have a choice of unique pre-entered items to select from.
Gord Dibben MS Excel MVP
On Thu, 1 Nov 2007 22:07:12 +0100, "Niek Otten" wrote:
DataValidationAllow:List
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Harvey" wrote in message ...
| What I want to do is: when I select a cell I want a list of choices to come
| up to choose from. I then pick the item and it is entered into the cell. I
| saw in one of excel websites and I cannot figure out how to do it. Would
| appreciate any help.
| Harvey
|
|