Data Validation references

G

Gerry Kuta

Hi,
I have a list of simple text items in [X1:X10]that I would
like to see in menu drop downs in cells A1 to A1000. When
I drag A1 (my first manually entered Data Validation
formatted cell) down to copy or copy A1 to paste special,
I loose 1 value from X1:X10 for each cell in [A] until it
is all gone and A11 is blank.
Can someone tell me what I'm doing wrong?

TIA,
Gerry
 
D

Dan E

Gerry,

Is it possible that you entered the Source of the data
validation range as =X1:X10. If so try:
=$X$1:$X$10

Dan E
 
G

Gerry Kuta

Yes I did, Thanks very much! It works fine now!
GK
-----Original Message-----
Gerry,

Is it possible that you entered the Source of the data
validation range as =X1:X10. If so try:
=$X$1:$X$10

Dan E

Hi,
I have a list of simple text items in [X1:X10]that I would
like to see in menu drop downs in cells A1 to A1000. When
I drag A1 (my first manually entered Data Validation
formatted cell) down to copy or copy A1 to paste special,
I loose 1 value from X1:X10 for each cell in [A] until it
is all gone and A11 is blank.
Can someone tell me what I'm doing wrong?

TIA,
Gerry


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top