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?

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?

=INDIRECT ($C$2) is the actual formula that appears after I enter =INDIRECT
(C2), and it will not update the reference if I fill down, cut or copy, and
paste.

"Max" wrote:

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?

You can always click inside the box & remove the $ signs manually.
With these $ removed, it'll copy ok when you drag down.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik
---
"jeffy" wrote:
=INDIRECT ($C$2) is the actual formula that appears after I enter =INDIRECT
(C2), and it will not update the reference if I fill down, cut or copy, and
paste.