Declamatory
Active Member
- Joined
- Nov 6, 2014
- Messages
- 319
Good morning,
I have a download table. For each date the right hand column represents the number of rooms available and the left hand number represents take up.
On a separate tab I need to be able to show how many rooms are still has left on each date for each room type.
Can anybody help me please.
Thanks
<tbody>
</tbody>
I have a download table. For each date the right hand column represents the number of rooms available and the left hand number represents take up.
On a separate tab I need to be able to show how many rooms are still has left on each date for each room type.
Can anybody help me please.
Thanks
Room Type | 19/10/2019 | 20/10/2019 | 21/10/2019 | 22/10/2019 | 23/10/2019 | 24/10/2019 | 25/10/2019 | 26/10/2019 | 27/10/2019 | 28/10/2019 | Total |
Allocated Shared Accommodation | '0/20' | '0/100' | '0/170' | '3/220' | '3/220' | '3/220' | '3/220' | '0/60' | '0/10' | '0/0' | '12/1,240' |
Single Occupancy Room | '0/80' | '0/170' | '1/350' | '11/490' | '11/490' | '11/490' | '11/490' | '1/200' | '0/20' | '0/0' | '46/2,780' |
Total | '0/100' | '0/270' | '1/520' | '14/710' | '14/710' | '14/710' | '14/710' | '1/260' | '0/30' | '0/0' | '58/4,020' |
<tbody>
</tbody>