drop down menu

  • Thread starter Thread starter alldreams
  • Start date Start date
A

alldreams

Hi,

Is there a way I could have a drop down menu in cell A1
where the values are in A5, A10, A15, and so on. I can't
use a validation list since it can only do it for cells in
sequence.

Thanks in advance
 
Try this set-up?

Put in B1: =INDIRECT("A"&ROW()*5)
Copy B1 down to B3, etc

B1 will return the value of A5
B2 will return the value of A10
B3 will return the value of A15
and so on

Name the range B1:Bx as say: MyTable
[where x = last row applicable]

Select A1

Click Data > Validation

In Settings tab:
Under Allow > choose "List"
Under "Source" put: =MyTable
Click OK

Now hide column B
 
Hi
one way:
use a helper column (lets say coolumn C - you can hide this column if
you like). Enter the following formula in C1:
=OFFSET($A$1,ROW()*5-1,0)
copy this down

Now use this column as data source for your data validation
 
Back
Top