"oasalako1" wrote in message
...
Hi,
Is there any one who can help. I have series of invoice numbers. I want
them
to be a able see all in any cell I point to and be able to pick the one I
need fro that cell. Please, kindly help.

Olu

I'm not sure if this is what you want, but let's try!

Put your invoice numbers in cells in a range, say A1:A10. (This is just an
example - you can make the list as long as you need.)
Select the cells where you want to be able to choose one from this list and
do
Data Validation
In the box called "Allow" choose "List".
Click in the box called "Source" and then select your range (A1:A10 in my
example).
Click "OK".
Now, whenever you select one of the cells you have just "validated", a
drop-down arrow will appear that will allow you to choose any value invoice
number.