Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
two columns range of numbers need to list all numbers in the range | New Users to Excel | |||
Condensing a list/range with blank cells to a new list/range without blanks | Excel Worksheet Functions | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
How can I use a named range for "pick from drop-down list"? | Excel Discussion (Misc queries) | |||
How do I Pick a cell with highest value from a range of cells? | Excel Worksheet Functions |