I have very basic knowledge of MS Excel compared to you guys. However, I am very keen to learn and grow my knowledge in Excel so please bear with me for what I have come up with. I would like a solution for this laborious manual work that I have to do for a whole fleet of vehicles.
Description:
- The source file is a monthly movement report for dedicated vehicles making multiple stops at different locations to load and offload products for the company. I have for your convenience included just one vehicle.
o The CLIENT destinations have been highlighted as Green.
o Beige/fawn colors are those where if the vehicle stays more than 30 mins, it should be regarded as one of the destinations. (since these are close to Client destinations and most probably have been parked outside)
o KDC in blue is also essentially a Client destination but for some purposes is highlighted in blue which need not be any cause for concern.
- Target file is the breakdown of the vehicle’s movement into round trips starting from Karachi and ending back in Karachi (Either FCL-the Plant OR WS – Workshop). This constitutes a round trip.
- Sample output file is the final report which I generate by manually putting all the dates & times from the source file to the target file.
Requirement:
Need to automatically extract date and time values against specified repetitive locations in the set output format in the target file. (If it could be bettered, I am open to any input).
Files included:
Sample output file
Source file
Target file
P.S. I also want to know how to properly protect my sheets.
Description:
- The source file is a monthly movement report for dedicated vehicles making multiple stops at different locations to load and offload products for the company. I have for your convenience included just one vehicle.
o The CLIENT destinations have been highlighted as Green.
o Beige/fawn colors are those where if the vehicle stays more than 30 mins, it should be regarded as one of the destinations. (since these are close to Client destinations and most probably have been parked outside)
o KDC in blue is also essentially a Client destination but for some purposes is highlighted in blue which need not be any cause for concern.
- Target file is the breakdown of the vehicle’s movement into round trips starting from Karachi and ending back in Karachi (Either FCL-the Plant OR WS – Workshop). This constitutes a round trip.
- Sample output file is the final report which I generate by manually putting all the dates & times from the source file to the target file.
Requirement:
Need to automatically extract date and time values against specified repetitive locations in the set output format in the target file. (If it could be bettered, I am open to any input).
Files included:
Sample output file
Source file
Target file
P.S. I also want to know how to properly protect my sheets.