List data query

  • Thread starter Thread starter Redsea
  • Start date Start date
R

Redsea

Hi I have created 3 lists on my worksheet via data validation and they
work great thanks to info in this forum.

The problem is in list 1 we will call it I have numbers ranging down
the column from 1 to 500. My first cell displays all numbers great but
as I move down and select another cell in the list the numbers only
start from that cell. In other words cell one displays the numbers 1 to
500.
If I go to cell 25 it only displays from 25 down to 500. My question is
how can I get all the numbers to show in my drop down list no matter
which cell I select.

TIA
 
Hi

You have to use absolute references (like $A$2:$A$500) in your list source
or in named range definition.

--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets


Redsea said:
Hi I have created 3 lists on my worksheet via data validation and they
work great thanks to info in this forum.

The problem is in list 1 we will call it I have numbers ranging down
the column from 1 to 500. My first cell displays all numbers great but
as I move down and select another cell in the list the numbers only
start from that cell. In other words cell one displays the numbers 1 to
500.
If I go to cell 25 it only displays from 25 down to 500. My question is
how can I get all the numbers to show in my drop down list no matter
which cell I select.

TIA


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top