Path: ccsf.homeunix.org!news.moat.net!border2.nntp.dca.giganews.com!nntp.giganews.com!newshosting.com!nx01.iad01.newshosting.com!news.glorb.com!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail
From: "Doug" <dhershman@arrowconcretewv.com>
Newsgroups: fj.comp.applications.excel
Subject: Data Validation sources
Date: 18 May 2005 11:16:54 -0700
Organization: http://groups.google.com
Lines: 11
Message-ID: <1116440214.184535.19250@g14g2000cwa.googlegroups.com>
NNTP-Posting-Host: 24.158.88.85
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1116440219 13217 127.0.0.1 (18 May 2005 18:16:59 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 18 May 2005 18:16:59 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=24.158.88.85;
   posting-account=VsucWQ0AAAB-J-6zbbkss4WZPuGI6OuG
Xref: ccsf.homeunix.org fj.comp.applications.excel:253

I have a basic spreadsheet and I am trying to use a data validation
with a source of a list of customers, and then use data validation with
a source that is driven from the choice made by the first validation.

eg. col A choose customer
    col B choose from a list of jobs for the customer selected in col a

My problem is setting the source code for the second validation.
If/then formulas require too many nests and references to cells imput
that cells contents and not the renge of information that I want.