data transfer does not match up

[Admin]

Hi

PFA.

[jeff]

Hi

Thanks

That is what I need except it does not transfer the Internal and External stops for the same date...it only transfers Planned Stops...the userform is correct in appearance but I need it to transfer all 3 stops together..(Planned,Internasl,External)

Thanks

[Admin]

Hi

It should be MS Internal and MS External

[jeff]

Thank you

[jeff]

Hi

I want to remove the Date from column O and replace with MS PLANNED,MS INTERNAL & MS EXTERNAL....the code to do as programmed except place the stop type in correct area instead of the date

I removed some of the code and it works for removing the date but am unable to get the Stops to show in the correct place

Just out of curiosity have I removed the unwanted code correctly (original file in post #12)

Thanks

[jeff]

I tried this code changed and it worked....do you see any issues with this change of code

Thanks

[Admin]

Looks good

[jeff]

Hi Admin

I need to add a further group..when the transfer for MS PLANNED,MS INTERNAL & MS EXTERNAL transfer can there also be another group transferred at the same time.....same criteria as MS ,look at the date ,Place the word "JUICE" in 'GROUP A'!O45,find all words with the name Juice in column K (JUICE-ORANGE and JUICE-PEAR) and sum up VOLUME and transfer to Sheet!Group A P45,same for Time in Column N and transfer to Q45...Place the word "WATER" in 'GROUP A'!O46,find all words with the name WATER in column K (WATER-CLEAR and WATER-COLORED) and sum up Volume and transfer to Sheet!Group A P46,same for Time in Column N and transfer to Q46...Place the word "ALC" in 'GROUP A'!O47,find all words with the name ALC in column K (ALC-RED and ALC-WHITE) and sum up Volume and transfer to Sheet!Group A P47,same for Time in Column N and transfer to Q47...
Sample Files shows the outcome..done manually to show
Thanks

[jeff]

bump