job tracking sheet(s)

[PaulMin]

I've been trying to hire someone to build a fairly simple, I think, form that would be filled in and populate a spreadsheet so we could track jobs from beginning to end. I've had no luck getting this done. So I'm looking for ideas here. This is basicly what I want.
[FONT=&quot]Upholstery shop work order tracking.[/FONT]

[FONT=&quot]A form to fill out that will populate the spreadsheet below. [/FONT]
[FONT=&quot]I would like a spreadsheet created to track the following. Clean and professional looking with the ability to print #’s 1,2,3,4,5,6,7,12,15 on a single sheet of paper easy to read that will follow the order through production process. There are really no formulas to the sheet just.[/FONT]

[FONT=&quot]This must be simple to use and update. No complex menus to navigate just a simple form to use to enter and update items. The printing should work easily also. Just check a line to print and all else falls into place. Example of printout included as a reference. Example does not contain all fields wanted.

[/FONT]Also it would be nice if these jobs could populate out google calendar as a scheduled item.

[FONT=&quot]1. Work order # created on the fly automated.[/FONT]
[FONT=&quot]2. Client name.[/FONT]
[FONT=&quot]3. Designer name if applicable.[/FONT]
[FONT=&quot]4. Item(s) might be 1 might be 10 might be 100 items.[/FONT]
[FONT=&quot]5. Fabric Company for each item.[/FONT]
[FONT=&quot]6. Fabric model for each item.[/FONT]
[FONT=&quot]7. Fabric color for each item.[/FONT]
[FONT=&quot]8. Fabric yardage for each item.[/FONT]
[FONT=&quot]9. Date fabric ordered, each item.[/FONT]
[FONT=&quot]10. Projected arrival date of fabric for each item.[/FONT]
[FONT=&quot]11. Back Order fabric status, each item.[/FONT]
[FONT=&quot]12. Misc. supplies needed for each item. Special nails, trim etc. For each item.[/FONT]
[FONT=&quot]13. Tentative Pickup date.[/FONT]
[FONT=&quot]14. Actual Pickup date.[/FONT]
[FONT=&quot]15. Tentative delivery date.[/FONT]
[FONT=&quot]16. Actual Delivery date.[/FONT]
[FONT=&quot]17. Misc. notes area.[/FONT]
[FONT=&quot]18. Actual production date of completion. (ready for delivery) Maybe a tick box to say it’s done.[/FONT]
[FONT=Gotham SSm, Helvetica, Arial, sans-serif]When #18 is true item can be moved to a separate SS or Tab to keep for record.[/FONT]

[FONT=Gotham SSm, Helvetica, Arial, sans-serif]So if anyone has an idea on how to accomplish this it would be much appreciated. I just cant seem to get my ideas across or the talent hasn't been there for me yet.[/FONT]

 

[Joe4]

The Forum is designed to be free help, to assist you in creating things for yourself. In which case, you would to post questions with very specific, singular tasks in mind.

If you are looking for someone to do it for you, or consult/guide you through the whole process from beginning to end, take a look at MrExcel Consulting Services: MrExcel.com | Excel Resources | Excel Seminars | Excel Products