How do i pick up a list of invoice numbers on a range of cells
 

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

How do i pick up a list of invoice numbers on a range of cells
 

On the cell where you want this to happen, click on Data | Validation
and on the Settings tab of the dialogue box click on the drop-down
under Allow. Select List and then put the cell references where your
invoice numbers are in the Source box. Click OK when finished.

Now when you select that cell you will see a pull-down which will give
you the list of invoice numbers when you click on it.

Hope this helps.

Pete

On Oct 18, 11:29 am, oasalako1
wrote:
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

How do i pick up a list of invoice numbers on a range of cells
 

"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.

How do i pick up a list of invoice numbers on a range of cells
 

ok, thanks. I found it
It Data/Validation/List/ then select the range.

Thank

"oasalako1" wrote:

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