S
Sandy
I have the following function defining the range "Grips". (The first value
to be used in the "M" column is in Row 3.)
=OFFSET(Jobs!$M$3,0,0,COUNTA(Jobs!$M:$M),1)
I then use the name "Grips" as a validation list "Source".
It works fine other than I get all the values plus a blank space at the
bottom of my drop-down list.
Any ideas?
Sandy
to be used in the "M" column is in Row 3.)
=OFFSET(Jobs!$M$3,0,0,COUNTA(Jobs!$M:$M),1)
I then use the name "Grips" as a validation list "Source".
It works fine other than I get all the values plus a blank space at the
bottom of my drop-down list.
Any ideas?
Sandy