create a drop down list from another workbook

Question

hi

a bit of a novice here.

i have excel 2003

i have an invoice that i created for myself in excel.

in the name/address section of my invoice, i want to have a drop down box and pick from a list of items that are stored in a different excel document.

how can i do this?

Answer 1

i dont know why.

i tried it from the website as well.

it tells me that it is evaluteing to an error

Answer 2

can you explain this part to me

sorry to bug you

create a range named CustomerList with the formula

=customer-vender list.xls!CUSTOMER

Answer 3

With costumer-vender list sheet open highlight column G including all the  names then go to the ribbon, Insert, name, define, define the name as CUSTOMER  and enter the following formula, I assumed the sheet where the names are is Sheet1 change it for yours

 =OFFSET(Sheet1!$G$1,0,0,COUNTA(Sheet1!$G:$G))

Leaving this workbook open open now the Master Memo workbook, create a range named CustomerList with the formula

=customer-vender list.xls!CUSTOMER

Then go to Data,Data Validation, in the allow box choose List, in the source box type

=CustomerList

click ok

Answer 4

sorry too confusing for me

maybe i give you my exact examples

i have one workbook called : costumer-vender list.xls

in colom g, i have the names and address in the cells

the title header of the colom is "NAME"

i have another workbook named : MASTER MEMO COPY.xls

in cell n3 , there is a box that requires to put in name and address

instead of copying and pasting into cell n3, everytime i want to create a new memo, i want to be able to choose the names from a drop down menu that looks up in the workbook " costumer-vender list.xls"

any suggestions?

Answer 5

Hi, take a look at Debra web

http://www.contextures.com/xlDataVal05.html