View Single Post
  #1   Report Post  
Marlis
 
Posts: n/a
Default link address book to invoice

how do I format the control

"bigwheel" wrote:

When you format the control use something like [customer.xls]Sheet1!$A$3:$A$5
as the input range

"Marlis" wrote:

I am trying to create a drop down list that allows me to insert the name and
address of a customer. My customer list is in a seperate worksheet.