ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Database Question? (https://www.excelbanter.com/excel-discussion-misc-queries/126498-database-question.html)

dbrumit

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

Sean Timmons

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


dbrumit

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


Debra Dalgleish

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


dbrumit

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



Debra Dalgleish

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



All times are GMT +1. The time now is 04:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com