create a queue for jobs

poonw

New Member
Joined
Feb 9, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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.
 

Attachments

  • Job Basket sheet.PNG
    Job Basket sheet.PNG
    30.5 KB · Views: 31
  • Job List sheet.PNG
    Job List sheet.PNG
    30.6 KB · Views: 30

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Forum statistics

Threads
1,223,896
Messages
6,175,260
Members
452,627
Latest member
KitkatToby

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top