Excel Invoice help

F

fredsat

i am try to make an invoice in excel that i can have a drop down bo
with numbers in 1 to 500 that when i pick one it will Auto Insert name
address form a spreed sheet i have with the name & address in it


Sorry if that do not make any sense as i new to excel


Many thank
 
C

Cimjet

i am try to make an invoice in excel that i can have a drop down box

with numbers in 1 to 500 that when i pick one it will Auto Insert name &

address form a spreed sheet i have with the name & address in it





Sorry if that do not make any sense as i new to excel





Many thanks

Hi
See link attached:
http://cjoint.com/?BHeojVdfr3c
It's a sample file
HTH
Cimjet
 
F

f.fred

i am try to make an invoice in excel that i can have a drop down box

with numbers in 1 to 500 that when i pick one it will Auto Insert name &

address form a spreed sheet i have with the name & address in it





Sorry if that do not make any sense as i new to excel





Many thanks

thats what i need how to i make the drop down list plz email me (e-mail address removed) thanks
 
S

Spencer101

thats what i need how to i make the drop down list plz email m
(e-mail address removed) thanks

Hi,

If you want you can email the current invoice file to me. I will hel
you accomplish what you need and give clear explanation of how it's don
so you can do the same in the future.

Email it to pubnut @ gmail . com (with no spaces
 
C

Cimjet

See this link with Instruction sheet:
Correction in the instruction, use these instruction.
These instruction are from Excel 2003 and if you're using 2007 or 2010, the menus are very different.

First, I created a name range by highlighting (Selecting) the numbers on the Customer Tab then going to menu "Insert>Name>Define. As per sample.
In the Top Window I type in the name range anything you like then press the ADD button. I called it "Account" and your done.
Now select the cell you want the dropdown and go to Data>Validation, choose List in the first window(Box) and in the second box type in the name of your Name range with the equal sign before it, as per sample. Make sure
"In-cell dropdown" is selected and your finish.
 
S

sbglobal2012

In spite of the fact that we need to invest in a printer and compute
for using this facility, it helps in the long run as effectively a
possible
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top