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....