HELP ME PLEASE EXCEL VBA CODES AND GANNT CHART (PRODUCTION SCHEDULE APP) If you are asked to do the homework; you can sort the entered jobs by drawing the Gannt Chart on the "Home Page" page, and find the Cmax and Tmax values. In the Gannt Chart, you are expected to automatically display the names and times of jobs in AutoFit. Everything in the Home Page sheet is linked to the VBA code and when the schedule button is pressed in the userform it should come automatically with the colors of the Gantt Chart.

JOB L?ST

Job code	Processing Time	Quantity	Total Process Time	Due Date	Start	Finish	Tardiness
J1	2	5	10	20	0	10	10
J2	4	6	24	40	25	49	-9
J3	3	3	9	25	10	19	6
J4	2	3	6	30	19	25	5

HOMEWORK EXCEL DOCUMENT SCREENSHOOTS

http://www.directupload.net/file/d/5052/xv2sgvq3_jpg.htm

http://www.directupload.net/file/d/5052/iv9xy3zr_jpg.htm

http://www.directupload.net/file/d/5052/v96ugn5y_jpg.htm