| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
link address book to invoice
"Marlis" wrote: I don't want to seem like a dunce, I guess what I'm asking is someone to tell me how to ell me the steps to be able to add a drop down list which I can click one name, and it will insert the mailing ifo. "bigwheel" wrote: OK. I assumed that you were using a drop down list which you put onto a worksheet using the Forms toolbar. Once placed on the sheet, right-click and choose "Format Contol" on the Control tab "Marlis" wrote: 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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace part of link address in a cell with a value(date) from ano | Excel Discussion (Misc queries) | |||
| excel as address book | Excel Discussion (Misc queries) | |||
| How do I stop e-mail address from turning into link in Excel? | Excel Discussion (Misc queries) | |||
| HOW DO I TRANSFER MY ADDRESS BOOK FROM MICROSOFT EXCEL TO PALM DE. | Excel Discussion (Misc queries) | |||
| How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
Threaded Mode
