Essentially I have a raw schedule, unorganized, I need someone to make it so by clicking a button the code looks through the spreadsheet and finds one of the following:
Buffet
Cocktail
Chefs
Thirst
Then in the same file on another worksheet takes that person's name and adds it to a pre designated section with their name and time ONLY.
The mock up is attached:
forum.ozgrid.com/index.php?attachment/49555/
Let me know your time frame and ask any questions to clear it up as I know my description is unclear but I'm very unsure how to clear it up.
Detail: The word "Close" in the time frame needs to stay as it is tentative to the amount of customers, and the times need to be in "normal" (non military time) as we don't want to run in to any confusion with our employees that aren't used to using military time.
Desired output:
forum.ozgrid.com/index.php?attachment/49558/