Data Validation List will not Fill Down

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?

demechanik
Tue Jul 22 22:04:02 CDT 2008

It seems to work ok for me
Maybe check that the DV>List'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?

jeffy
Wed Jul 23 08:24:00 CDT 2008

=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 DV>List'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?

demechanik
Wed Jul 23 09:20:07 CDT 2008

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.