Dear Gurus,
I have a vessel master schedule in excel spreadsheet. Incase a vessel is behind schedule the master schedule can be tweaked to ensure schedule recovery and vessel informed accordingly of the result which is to be adhered by the vessel. Therefore the result sheet is linked to the master schedule sheet. Now, if there is one vessel this works well but i would like to link six sheets (one for each of the six vessels). One way would be to make six copies of the master schedule to which the six result sheets are attached. However, my idea is to have one master schedule sheet which will have a dropdown box from where one of the six vessels is chosen. Once the vessel “A” is chosen the last worked data of the vessel “A” should show up. Thereafter as the data in the master schedule is tweaked the result sheet for the vessel “A” will update as it is linked to the master schedule. Thereafter, the data for vessel “A” is saved. Then vessel “B” is selected which should then show the last worked data of the vessel “B”. Any tweaking of the master schedule for vessel be will update the results sheet of vessel “B” and so on with other vessels.
can any one help me in resolving the above problem.
regards
