Shrinking List through Data Validation

[cLiffordiL]

Hi!
I've a Cover sheet (sheet1) for presentation & a Data sheet (sheet2) where
all the data are. In my Cover sheet, I've had a column where 3 connecting
cells (Sheet1!B2:B4) having data validation dropdown list from a named list
(MyList - Sheet2!$A2:$A65536) from my Data sheet. The funny thing I notice
is while the topmost cell (B2) might contain the full list, each cell
beneath are missing of the topmost entry of the previous list. This means
the list

in B2 is Sheet2!$A2:$A65536,
in B3 is Sheet2!$A3:$A65536,
in B4 is Sheet2!$A4:$A65536.

I thouught that by using a named list in my data validation, such
scenarios should not happen. Anyone got any idea why and how to fix this?
Thanks.
________
cLiffordiL

 

[Debra Dalgleish]

The named list should have absolute row references:
Sheet2!$A$2:$A$65536

Unless you have entries in every row, a dynamic list may be a better
solution. There are instructions here:

http://www.contextures.com/xlNames01.html