Will need help as I am trying to consolidate information on a worksheet onto a separate worksheet.
I have a worksheet with deployment of staff for different venues at different timing. My staff finds it tedious to be looking at multiple worksheets checking on their name over a span of 10 days.
Will like to enquire whether there is a possibility for the names to be consolidated on a separate worksheet which can allow them to easily identify their allocated venue and timing.
By: William Goh