Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2007

Tip: Looking for answers? Try searching our database.

Is an array the best option for me and if so how ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
clive.churchward@googlemail.com - 01 Sep 2007 13:36 GMT
Good Morning

I am trying to set a comparison of shipping costs
possibly using a pick list and/or an array but I cant get my head
around all the different option

I want to be able to choose a county and this gives me the zones for
each carrier and from this it would calclate the
shipping cost for each carrier

I have created apicklist of every county in the world so I though
I next need to give each country a zone number whch if defferent for
every carrier

so if a choose Ireland I need the rules to show each code

ie

CARRIER          =                        TNT       CITY
UPS              DHL
-------------------------------------------------------------------------------------------------------
IRELAND                                      T1           C3
U6               D8

Any help would be must appreciated
Regards Clive

clive.churchward@googlemail.com
MartinW - 01 Sep 2007 14:32 GMT
Hi Clive,

Your scope is a bit too broad for the sort of advice
you will achieve here. Debra Dalgleish has covered
most, if not all, of the techniques you will require
at her Contextures site. Here is the link,
http://www.contextures.com/tiptech.html

The Data Validation techniques are probably the most relevant
to your needs, but I am sure there are a few others that
will come in handy.

Post back here to the newsgroups about more specific problems
as they crop up.

HTH
Martin

> Good Morning
>
[quoted text clipped - 24 lines]
>
> clive.churchward@googlemail.com

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.