Validation List

[The Todal]

I'm trying (without success) to figure out how to make the validation list in B1 subject to the item selected in A1. Any suggestions? TIA

 

[dave3009]

More than welcome.

Never got to Carnoustie, went to Kendal instead. One of my mates just bought a farm stead so he wanted some free advice on what to do.

Hope you're enjoying the fine golfing action.

Kindest Regards


Dave

 

[dave3009]

And you don't need to put the second drop down downwards you can condense the data

Book1 (version 1).xls
	A	B	C	D	E	F	G
1
2
3
4		Rep1	a	b	c	d	e
5		Rep2	f	g	h	i	j
6		Rep3	k	l	m	n	o
7		Rep4	p	q	r	s	t
8
9		2	3	4	5	6
10		a	b	c	d	e
11
12	Rep1	a
13
Sheet1