It seems to work ok for me
Maybe check that the DVList's source formula
reads something like: =INDIRECT(C2)
(ie a relative reference for row "2")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik
---
"jeffy" wrote:
I am using data validation lists on a large spreadsheet. I have one list
populated from a series of data I specify. I then use the INDIRECT function
to call the list for my second drop down box based on the data in the first
box.

When I copy the cells, the formula in the Source box in the data validation
screen does not increment to maintain the proper reference (it stays at C2
instead of updating to C3, C4 etc...)

Is there a quick way to "fill down" my spreadsheet so these lists will work?