software

Hi,

I have defined a named list (A1:A500 named CompanyNames). The list
currently only has 3 items but gradually companies will be added to
this list. In a second sheet I have specified the list CompanyNames
under validation for all cells in column B. When I click a cell with
this validation defined I only want to see the values of the cells that
have data in it. Currently I see a list with 3 company names and 497
blank lines. Is it possible to only see the 3 companany names in the
list and not the blank cells?

Thanks in advance for your help.

Sp00k--
Sp00k
------------------------------------------------------------------------
Sp00k's Profile: www.excelforum.com/member.php...oamp;userid=33676
View this thread: www.excelforum.com/showthread...hreadid=536465Isn't there an quot;ignore blank cellsquot; check box when you go to select the cells
for you list? I think it is on the right side

Neil

quot;Sp00kquot; wrote:

gt;
gt; Hi,
gt;
gt; I have defined a named list (A1:A500 named CompanyNames). The list
gt; currently only has 3 items but gradually companies will be added to
gt; this list. In a second sheet I have specified the list CompanyNames
gt; under validation for all cells in column B. When I click a cell with
gt; this validation defined I only want to see the values of the cells that
gt; have data in it. Currently I see a list with 3 company names and 497
gt; blank lines. Is it possible to only see the 3 companany names in the
gt; list and not the blank cells?
gt;
gt; Thanks in advance for your help.
gt;
gt; Sp00k
gt;
gt;
gt; --
gt; Sp00k
gt; ------------------------------------------------------------------------
gt; Sp00k's Profile: www.excelforum.com/member.php...oamp;userid=33676
gt; View this thread: www.excelforum.com/showthread...hreadid=536465
gt;
gt;

Define CompanyNames with a RefersTo value of

=OFFSET($A$1,,,COUNTA($A:$A),1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Sp00kquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; I have defined a named list (A1:A500 named CompanyNames). The list
gt; currently only has 3 items but gradually companies will be added to
gt; this list. In a second sheet I have specified the list CompanyNames
gt; under validation for all cells in column B. When I click a cell with
gt; this validation defined I only want to see the values of the cells that
gt; have data in it. Currently I see a list with 3 company names and 497
gt; blank lines. Is it possible to only see the 3 companany names in the
gt; list and not the blank cells?
gt;
gt; Thanks in advance for your help.
gt;
gt; Sp00k
gt;
gt;
gt; --
gt; Sp00k
gt; ------------------------------------------------------------------------
gt; Sp00k's Profile:
www.excelforum.com/member.php...oamp;userid=33676
gt; View this thread: www.excelforum.com/showthread...hreadid=536465
gt;

There is, but it doesn't appear to do a lot.--
Sp00k
------------------------------------------------------------------------
Sp00k's Profile: www.excelforum.com/member.php...oamp;userid=33676
View this thread: www.excelforum.com/showthread...hreadid=536465
Hi Bob,

It took me a while to get it right (newbie problems ) but I got it
working in the end with your advice. Thanks a lot for your help.

Sp00k--
Sp00k
------------------------------------------------------------------------
Sp00k's Profile: www.excelforum.com/member.php...oamp;userid=33676
View this thread: www.excelforum.com/showthread...hreadid=536465