MrTommey232
New Member
- Joined
- Nov 17, 2016
- Messages
- 5
hi everybody
I would love to get your help in either Vba of formula, to get a nice looking report.
here is what my data likes like
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 207px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>And here is what i want to get in the end for every name:
d.l room1 9-10 room2 10-11 room 3 11-12.
n.d room 2 9-10 room 3 10-12.
t.k room 2 9-12.
the biggest issue that I have is, the goning back and forth of names from one room to anther, and cameing back to the same room in a different hour.
for exm. d.l is in room 1 in 9-10 then going to room 2 in 10-11 and then cameing back again to room 1 in 11-12.
Thx for all the help in advance.
Tom.
I would love to get your help in either Vba of formula, to get a nice looking report.
here is what my data likes like
time | room 1 | room2 | room3 |
9-10 | d.l | t.k | n.d |
9-10 | m.e | n.d | s.h |
9-10 | l.a | t.g | e.n |
10-11 | d.l | n.d | |
10-11 | m.e | s.h | t.k |
10-11 | l.a | e.n | t.g |
11-12 | d.l | t.k | n.d |
11-12 | s.h | m.e | e.n |
11-12 | t.g | l.a |
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 207px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
t.g |
<tbody>
</tbody>
d.l room1 9-10 room2 10-11 room 3 11-12.
n.d room 2 9-10 room 3 10-12.
t.k room 2 9-12.
the biggest issue that I have is, the goning back and forth of names from one room to anther, and cameing back to the same room in a different hour.
for exm. d.l is in room 1 in 9-10 then going to room 2 in 10-11 and then cameing back again to room 1 in 11-12.
Thx for all the help in advance.
Tom.