Hello everybody,
Let’s say that I have a spreadsheet that represents a calendar; dates across the top and workers names down the side. The spreadsheet is used to record picking discrepancies in our warehouse.
The ‘calendar’ sheet cells are colour coded to denote the reason code, and the detail of the discrepancy is entered into a different worksheet; information like pick location, item number and reason code are entered here into separate columns.
Here is what I am after. I’d like to be able to view the detail of the discrepancy from the calendar sheet, i.e. either click or hover over a colour-coded cell to launch a text box that summarises the detail.
How does that sound?
Thanks, Kenny.
Let’s say that I have a spreadsheet that represents a calendar; dates across the top and workers names down the side. The spreadsheet is used to record picking discrepancies in our warehouse.
The ‘calendar’ sheet cells are colour coded to denote the reason code, and the detail of the discrepancy is entered into a different worksheet; information like pick location, item number and reason code are entered here into separate columns.
Here is what I am after. I’d like to be able to view the detail of the discrepancy from the calendar sheet, i.e. either click or hover over a colour-coded cell to launch a text box that summarises the detail.
How does that sound?
Thanks, Kenny.