data transfer does not match up

[jeff]

With userform the criteria is Date and Team Sheet (a or b or c) and either day,afternoon,night or All (all 3 shifts) to have exact match for transfer of data to Group A sheet.....currently it does not place data in Group A correctly....

This line errors


arrOP_PS(PSCounter, 1) = CDate(Data(CurrentRow, 1)) 'date

[Admin]

Hi

PFA.

[jeff]

Thanks Admin

Works well except it places Planned Stops also in the Machine Stops-external....places Planned Stops correctly at the Planned Stops range but also in the Machine Stops-External range

Thanks again

[Admin]

PFA.

[jeff]

Thanks Admin

Works great...if I want to say just use All and not Day,Afternoon and Night individually what part of the code would I Comment out (just in case I want to use again)....saves deleting this part of the code

Thanks again

[Admin]

Hi

It's already considering the shift. See these part of the code


If Shift = "all" Then 'all
CREATE_OUTPUT i, LB
ElseIf Data(i, 2) = Shift Then 'match shift
CREATE_OUTPUT i, LB
End If

[jeff]

Thanks Admin

As I now transfer all 3 shifts and all 3 Stops everytime which part of the code do I change please?

I only need the Date and Team groups plus the commandbutton on the Userform as everytime I transfer I will be transferring every shift and every stop so do not need the options to select individually

Thanks and happy new year

[jeff]

bump

[Admin]

Hi

I'm not clearly understand the query ? Can you rephrase the query ?

[jeff]

Can the option of selecting Day,Afternoon and Night be removed as I transfer all 3 shifts each time .. I also need the option of Planned Stops,Unplanned Stops Internal and External removed as I want to transfer all 3 each time....I changed the userform to show what I mean...When I select the Userform all I need to select is a Date and a Team.....When a date and Team is selected and I then press transfer button it needs to Transfer All shifts and All Stops for the exact date and team....

[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