| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Database Question?
I have a form used for shipping and would like to select ship to adresses
from a list or with a code maybe? i do not have acess. Could someone help me set this up? Thanks, Dan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Database Question?
Hopefully, this list is not too large
in the desired cell, go to Data-Validation select from: List Highlight the list of ship to addresses. "dbrumit" wrote: I have a form used for shipping and would like to select ship to adresses from a list or with a code maybe? i do not have acess. Could someone help me set this up? Thanks, Dan |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Database Question?
Thanks for the quick response, I am very new to this, our list of addresses
would only be about 10 or so. I am having trouble getting the street, city state and zip to line up. Example would be: Column A Column B Ship to: 123 company 45 test road Anytown, DE 19713 Can this be done? Thanks, Dan "Sean Timmons" wrote: Hopefully, this list is not too large in the desired cell, go to Data-Validation select from: List Highlight the list of ship to addresses. "dbrumit" wrote: I have a form used for shipping and would like to select ship to adresses from a list or with a code maybe? i do not have acess. Could someone help me set this up? Thanks, Dan |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Database Question?
There are instructions here for adding a customer address to an order
form, that you could adapt to your workbook: http://www.contextures.com/xlOrderForm01.html dbrumit wrote: Thanks for the quick response, I am very new to this, our list of addresses would only be about 10 or so. I am having trouble getting the street, city state and zip to line up. Example would be: Column A Column B Ship to: 123 company 45 test road Anytown, DE 19713 Can this be done? Thanks, Dan "Sean Timmons" wrote: Hopefully, this list is not too large in the desired cell, go to Data-Validation select from: List Highlight the list of ship to addresses. "dbrumit" wrote: I have a form used for shipping and would like to select ship to adresses from a list or with a code maybe? i do not have acess. Could someone help me set this up? Thanks, Dan -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Database Question?
Thank you, this is just what I was looking for!
"Debra Dalgleish" wrote: There are instructions here for adding a customer address to an order form, that you could adapt to your workbook: http://www.contextures.com/xlOrderForm01.html dbrumit wrote: Thanks for the quick response, I am very new to this, our list of addresses would only be about 10 or so. I am having trouble getting the street, city state and zip to line up. Example would be: Column A Column B Ship to: 123 company 45 test road Anytown, DE 19713 Can this be done? Thanks, Dan "Sean Timmons" wrote: Hopefully, this list is not too large in the desired cell, go to Data-Validation select from: List Highlight the list of ship to addresses. "dbrumit" wrote: I have a form used for shipping and would like to select ship to adresses from a list or with a code maybe? i do not have acess. Could someone help me set this up? Thanks, Dan -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Database Question?
You're welcome! Thanks for letting me know that it helped.
dbrumit wrote: Thank you, this is just what I was looking for! "Debra Dalgleish" wrote: There are instructions here for adding a customer address to an order form, that you could adapt to your workbook: http://www.contextures.com/xlOrderForm01.html dbrumit wrote: Thanks for the quick response, I am very new to this, our list of addresses would only be about 10 or so. I am having trouble getting the street, city state and zip to line up. Example would be: Column A Column B Ship to: 123 company 45 test road Anytown, DE 19713 Can this be done? Thanks, Dan "Sean Timmons" wrote: Hopefully, this list is not too large in the desired cell, go to Data-Validation select from: List Highlight the list of ship to addresses. "dbrumit" wrote: I have a form used for shipping and would like to select ship to adresses from a list or with a code maybe? i do not have acess. Could someone help me set this up? Thanks, Dan -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get Data from a secured Access database | Excel Discussion (Misc queries) | |||
| make existing pivot charts point at the same database | Charts and Charting in Excel | |||
| Database Functions - question using formulas as criteria | Excel Worksheet Functions | |||
| Import from Database using field from excel. | Excel Discussion (Misc queries) | |||
| The Template Wizard retains the original location for my database | Excel Discussion (Misc queries) | |||
Linear Mode
