Hello experts,
(See attached example workbook)
I would like excel to automatically create a Textbox (or anything else that you may think suitable) in the "Job Basket" tab when Column B of "Job List" tab is filled in with a time. Other features I would like to have:
-The users can use the "Job Basket" tab to queue jobs into different baskets (e.g. Basket 1,2,3)
-Once a job is in the basket (i.e. being processed) it will feedback info in the "Job List" tab Column C to indicate the job is being processed and as well as time stamp the time the job is in the basket (column D).
-Once the job has been processed in the basket the user can click on the Textbox to make it disappear (or something equivalent), output the time in Job list tab column E and queue the next job into the basket.
-Then repeat
-I would also like the user to be able to "freely" move the "jobs" in the "Job Basket" tab so that if needed a job can "jump queue".
I know it is complicated I hope it's not too much to ask for thank you guys in advance.
(See attached example workbook)
I would like excel to automatically create a Textbox (or anything else that you may think suitable) in the "Job Basket" tab when Column B of "Job List" tab is filled in with a time. Other features I would like to have:
-The users can use the "Job Basket" tab to queue jobs into different baskets (e.g. Basket 1,2,3)
-Once a job is in the basket (i.e. being processed) it will feedback info in the "Job List" tab Column C to indicate the job is being processed and as well as time stamp the time the job is in the basket (column D).
-Once the job has been processed in the basket the user can click on the Textbox to make it disappear (or something equivalent), output the time in Job list tab column E and queue the next job into the basket.
-Then repeat
-I would also like the user to be able to "freely" move the "jobs" in the "Job Basket" tab so that if needed a job can "jump queue".
I know it is complicated I hope it's not too much to ask for thank you guys in advance.