J
jeffy
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?
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?