Hey again everyone
Me again lol, I have attached the below sample of our large database, not sure how simple this request will be, or whether it is a formula instead of a Macro???? We are a large shipping company.
Within our company we have 40 "KITS" these are sets of equipment. Each one has its own worksheet, on the sample attached there is only 2. KIT001, KIT002.
Each worksheet is a record of where that equipment has been, on what dates, from what locations, on what ship, what project number it is....
The "vessel" worksheet is a visual calendar of all 40 KITs, Row 1 and 2 are the dates, and just run continuously for ever....so each column relates to a specific date the remaining rows correspond to a different KIT. I manually complete the "vessel" Worksheet. As per the 3 examples already complete for KIT001 Worksheet.
For each Row on a "KIT00?" worksheet, it equates to a Job/Deployment on a ship, I would like it so, once a date is entered into column C, whatever is in column J on that same row, is populated into the corresponding date shown in Column C for the specific KIT, on the Vessel Worksheet.
Sooooooo....Hopefully not lost everyone....
I have filled out the data for KIT001 as an example, I have placed data in KIT002.
EG.
For KIT one it has three jobs, the first entry in in ROW 5 on the KIT001 worksheet, the embarkation date is the 6/1/2015 Cell C5, once this is entered I want whatever is in Column J of the same row, Cell J5 to be automatically put into the Veesl Worksheet, in the corresponding Column of the 6/1/2015 on the RO for KIT001, cell J3.
And so on for every row entry in the KIT00? worksheets.
Thanks for all your help and if its possible....
Much appreciated.
Claire
Bookmarks