Hello to all on this board,
Firstly may I say what a great help you guys have been over the last few months reading your forum, i'm a bit of an excel fanatic and love the puzzles it can give you, but i have come accross an absolute stand still over this past week and really could do with your help.
I have been tasked to summarise an ongoing tracker that has been going for some time at work, I have been able to import all the data from 5 sheet into one using VBA, now i require a way to select the following.
<tbody>
</tbody>
As you can see from above the data is a bit mixed, I need a way so in a seperate sheet("Sheet1") in say d1=dept d2 = crew this would would give me just ie the name, dept 7 Crew of dept z and crew 1 starting in cell a2 on this("Sheet1"). I have been trying to use index & match, row numbers and large but it's just getting me down with a hurdle every time. i realise i may need to add row numbers of some sort as say Dept Z & crew 1 can be repeated over 100 times.
Finished ideal result in seperate sheet..
<tbody>
</tbody> Thanks for your help in advance guys, it would really be appreaciated as i have been up many early mornings trying to figure this out.
Firstly may I say what a great help you guys have been over the last few months reading your forum, i'm a bit of an excel fanatic and love the puzzles it can give you, but i have come accross an absolute stand still over this past week and really could do with your help.
I have been tasked to summarise an ongoing tracker that has been going for some time at work, I have been able to import all the data from 5 sheet into one using VBA, now i require a way to select the following.
Name | Dept | Crew |
a | z | 1 |
b | z | 1 |
c | z | 2 |
d | z | 3 |
e | y | 2 |
f | y | 2 |
g | y | 1 |
h | y | 1 |
i | x | 1 |
j | x | 2 |
k | x | 3 |
<tbody>
</tbody>
As you can see from above the data is a bit mixed, I need a way so in a seperate sheet("Sheet1") in say d1=dept d2 = crew this would would give me just ie the name, dept 7 Crew of dept z and crew 1 starting in cell a2 on this("Sheet1"). I have been trying to use index & match, row numbers and large but it's just getting me down with a hurdle every time. i realise i may need to add row numbers of some sort as say Dept Z & crew 1 can be repeated over 100 times.
Finished ideal result in seperate sheet..
Dept | z | ||||
Name | Dept | Crew | crew | 1 | |
a | z | 1 | |||
b | z | 1 | |||
c | z | 1 | |||
d | z | 1 | |||
e | z | 1 | |||
f | z | 1 |
<tbody>
</tbody>