I am building a workbook which will be used to quote cleaning jobs and i want to add a drop down selection menu with hidden values which will help calculate timings for jobs - for example
if you select DOOR WITH VISION PANEL i want that to have a hidden value that is the time it takes to clean e.g. 1 minute the auditor then enters the number of doors lets say 3 and the spreadsheet can then calcutalet that 3 doors with vision panels will take 3 minutes to clean
can anyone help
Bookmarks