ASSEST TRACKING - Automatically plot on a calendar when Assets are used.

Good afternoon everyone.

Thanks for taking the time to look at my problem.

The easiest way I think of explaining this is to attach a template then try to explain. See attached. It is for tracking equipment on ships.

I have 2 worksheets, TASK and CALENDAR.

On TASK i want to add in an upcoming job, VESSEL NAME, KIT to be used, EMBARKATION LOCATION and EMBARKATION DATE, and DISEMBARKATION LOCATION and DISEMBARKATION DATE.

I want this to automatically fill in on the CALENDAR Worksheet. I have manually filled in an example on the CALENDAR worksheet.

The CALENDAR worksheet needs to fill in the range the equipment has been used, in the colour for that KIT (shown in column A), then in the left most cell that is coloured must say EMBARKATION LOCATION, 4 spaces, VESSEL NAME, 4 space, DISEMBARKATION LOCATION.

In reality I have 50 Kits with over 100 Tasks a month, so manually inputting every task into the CALENDAR is very time consuming.

As a new task is raised I want to insert a new row at the top of the TASK worksheet (in row 2 under the headings) so the most recent is always at the top.

Again thanks so much for any help you can give me.

Claire

Please help me