Hi all
I am facing a challenge:
I have few rooms with multiples equipment inside. For each equipment I need to answer 9 questions, there is only 3 option: red, orange or green.
The list with all the equipment by room are built as bellow:
<tbody>
</tbody>
In a different sheet I have this table with the answers:
<tbody>
</tbody>
To be able to built a pivot table, I need to present the data like:
<tbody>
</tbody>
And so on. The only problem that my database is big as ****. So I need to generate a VBA for it.
Someone could give me a light on this?
Cheers.
****** id="cke_pastebin" style="position: absolute; top: 606.4px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody>
I am facing a challenge:
I have few rooms with multiples equipment inside. For each equipment I need to answer 9 questions, there is only 3 option: red, orange or green.
The list with all the equipment by room are built as bellow:
Room 1 | Room 2 | Room 3 |
Equipment X | Equipment Y | Equipment Z |
Equipment XZ | Eq YX | Eq ZX |
Eq ZY | Eq XZY | Eq ZXY |
<tbody>
</tbody>
In a different sheet I have this table with the answers:
Equipment | Question 1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 |
X | Red | R | R | Orange | Green | G | G | G | G |
Y | R | R | R | R | O | O | G | G | G |
Z | G | G | R | R | O | O | G | G | G |
XZ | G | G | G | G | G | G | G | R | G |
YX | G | R | G | G | G | G | G | G | O |
ZX | G | G | G | G | G | G | G | G | G |
ZY | R | R | G | G | G | G | G | G | G |
XZY | O | O | G | G | G | G | G | G | G |
ZXY | O | O | O | G | G | G | G | G | G |
<tbody>
</tbody>
To be able to built a pivot table, I need to present the data like:
Room | Equipment | Answers in Red | Answers in Orange |
Room1 | X | R | |
Room1 | X | R | |
Room1 | X | O | |
Room1 | XZ | R | |
Room1 | ZY | R | |
Room1 | ZY | R | |
Room2 | Y | R | |
Room2 | Y | R | |
Room2 | Y | R | |
Room2 | Y | R | |
Room2 | Y | O | |
Room2 | Y | O |
<tbody>
</tbody>
And so on. The only problem that my database is big as ****. So I need to generate a VBA for it.
Someone could give me a light on this?
Cheers.
****** id="cke_pastebin" style="position: absolute; top: 606.4px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
O |
<tbody>
</tbody>