List data query

[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

 

[Arvi Laanemets]

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

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

creating financial statements

 

[Redsea]

Its Ok guys I sorted it thanks anyway