data validation - copy/drag issue

[blundastruck]

If this question has been answered before, I haven't discovered it yet. Please post the link and if its the answer, I'll mark my post Answered.

I have a workbook that uses one sheet to list all values I want to choose from. On the second sheet, I've used Data Validation to select from that 1st sheet's values.

The problem comes when I try to copy that validation to other cells in the same 2nd sheet. I use the copy/drag option (the crosshairs icon) to change 30-40 cells to format those cells to the validation. But, when I choose from my pull-down menu I've set up, on each row, there's one LESS option to choose from.

If I've got a list with 10 values, the first row shows all of the options. On the 2nd row, only 9 options show up. 3rd row, 8 options.

I want to have the 10 values in that list on each line. How do I fix this?

 

[Joe4]

Are you using Absolute Value Referencing to lock your ranges down, like this?
=Sheet2!$A$1:$A$10
(note the dollar signs before the row and column references).

If you have it like this (without the dollar signs):
=Sheet2!A1:A10
the ranges will move as you copy it down.

See here foir details: Switch between relative, absolute, and mixed references

 

[blundastruck]

Are you using Absolute Value Referencing to lock your ranges down, like this?
=Sheet2!$A$1:$A$10
(note the dollar signs before the row and column references).

If you have it like this (without the dollar signs):
=Sheet2!A1:A10
the ranges will move as you copy it down.

See here foir details: Switch between relative, absolute, and mixed references

You have just solved a LOT of my frustration! THANK YOU

 

[Joe4]

You are welcome!
Glad I was able to help.