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
Bookmarks