C
Chuckles
Hi,
I am working on a large register of equipment and have a problem.
I need to create a list automatically based on the contents in one cell. I
have a equipment register on one sheet (Sheet 1) and wish a list to be
automatically generated via the info in a cell on Sheet 2, ive tried to show
what I mean below.
Sheet 1 data:
A B C D
1 Drill Yellow Parent Blue
2 Drill Yellow Child Blue
3 Drill Yellow Child Blue
4 Saw Black Parent Silver
5 Drill Yellow Parent Red
6 Hammer Brown Parent Hook
Sheet 2 data:
A B C D
1 Drill Parent
2
3 Drill Yellow Parent Blue
4 Drill Yellow Parent Red
5
6
A1 & B1 have the criteria i.e Drill & Parent, the list I want in generated
is shown from A3 down and across
What formula would I need to do this?
Many thanks in advance,
Chucks
I am working on a large register of equipment and have a problem.
I need to create a list automatically based on the contents in one cell. I
have a equipment register on one sheet (Sheet 1) and wish a list to be
automatically generated via the info in a cell on Sheet 2, ive tried to show
what I mean below.
Sheet 1 data:
A B C D
1 Drill Yellow Parent Blue
2 Drill Yellow Child Blue
3 Drill Yellow Child Blue
4 Saw Black Parent Silver
5 Drill Yellow Parent Red
6 Hammer Brown Parent Hook
Sheet 2 data:
A B C D
1 Drill Parent
2
3 Drill Yellow Parent Blue
4 Drill Yellow Parent Red
5
6
A1 & B1 have the criteria i.e Drill & Parent, the list I want in generated
is shown from A3 down and across
What formula would I need to do this?
Many thanks in advance,
Chucks