Data validation fill right issue

[marcellusw101]

I'm sure someone else has posted this but I just can't find it. I'm on Excel 2010.

I am creating a series of drop-down lists, one for each column. In A1, the drop-down list is composed of cells A10:A11. The B2 list is composed of cells B10:B11, and so forth.

When I create the list using data validation for A1, then fill right, the drop-down lists in B1, C1, etc. all have the values from A10:A11. My question is how do I easily fill right so that the values in the list change according to the column where the list resides?

I feel like there's an obvious solution but I am stumped.

Thanks!

 

[cdchapman]

For the dropdown list for column A, enter the Source as =A$10:A$11. That way the row references will remain the same, but the column references will change to B, C, D etc when you copy the data validation to other columns.

 

[marcellusw101]

That's what I tried, but it doesn't work. When I fill right, the validation for column B, C, etc. remains A10:A11.

 

[marcellusw101]

Okay, I figured it out. As I suspected, I am a moron.

The validation formula had absolute references - $A$10:$A$11. When I removed the $ from the columns it filled fine.

Sorry for wasting everyone's time!