data validation drop-down menu blank entry

I assign "names" equipment for worksheet1 COLUMN 'B' that contain

A B
1
2 primary
3 secondary
4 tool
5 gauge
6 cutter
7
8
9
10
11
12
...


For worksheet2 I assign cell b2 as data validation

Allow -> list
Source = equipment
Ignore blank -> check


However, after I copy the data validation to the rest of the row, something
weird happen

From cell b3 onward, clicking on the drop-down show the last blank cell
first, instead of showing the 1st value "primary".
The next cell b4, however doesnt have the 1st value "primary"
Cell b5 doesnt have 1st and 2nd value, and so on so forth,

Make sure that the formula for the Equipment named range is an absolute
reference, e.g.:

=Sheet1!$B$1:$B$5

not

=Sheet1!B1:B5

crapit wrote:
> I assign "names" equipment for worksheet1 COLUMN 'B' that contain
>
> A B
> 1
> 2 primary
> 3 secondary
> 4 tool
> 5 gauge
> 6 cutter
> 7
> 8
> 9
> 10
> 11
> 12
> ...
>
>
> For worksheet2 I assign cell b2 as data validation
>
> Allow -> list
> Source = equipment
> Ignore blank -> check
>
>
> However, after I copy the data validation to the rest of the row, something
> weird happen
>
> From cell b3 onward, clicking on the drop-down show the last blank cell
> first, instead of showing the 1st value "primary".
> The next cell b4, however doesnt have the 1st value "primary"
> Cell b5 doesnt have 1st and 2nd value, and so on so forth,
>
>
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

"crapit" <[email protected]> wrote in message
news:e0%[email protected]...
>I assign "names" equipment for worksheet1 COLUMN 'B' that contain
>
> A B
> 1
> 2 primary
> 3 secondary
> 4 tool
> 5 gauge
> 6 cutter
> 7
> 8
> 9
> 10
> 11
> 12
> ...
>
>
> For worksheet2 I assign cell b2 as data validation
>
> Allow -> list
> Source = equipment
> Ignore blank -> check
>
>
> However, after I copy the data validation to the rest of the row,
> something weird happen
>
> From cell b3 onward, clicking on the drop-down show the last blank cell
> first, instead of showing the 1st value "primary".
> The next cell b4, however doesnt have the 1st value "primary"
> Cell b5 doesnt have 1st and 2nd value, and so on so forth,
>

You need to use absolute addressing for your data validation. That is, use
$B$2 instead of B2.