Here is the template of the document I'm using, as previously mentioned I want to link the names from the front sheet to the room numbers on the occupancy page. The room numbers can change from day to day, so I need changes made to room Nos to reflect in who is in what room on the occupancy page
I thought I'd got Tony's method fixed in my head but no, it went down the plughole when I tried to transpose his test.xlsm to this workbook
|