Hi,
I am very new to VBA and would like to use VBA to populate a shift roster pattern based on 3 conditions (Plant mode, calculation of date to roster cycle and shift team).
The pattern would need to be populated to a dynamic range of dates based on the plant mode (Range E3:H6), roster cycle day ( range E1:H1) and the shift (C9:C12).
The result should be populated to sheet 1 range E9:H12.
My assumption in that the lookup function will need to be looped through a dynamic range of date.
Any help would be greatly appreciated as I have not been able to find/understand an example like this so far.
Thanks
I am very new to VBA and would like to use VBA to populate a shift roster pattern based on 3 conditions (Plant mode, calculation of date to roster cycle and shift team).
The pattern would need to be populated to a dynamic range of dates based on the plant mode (Range E3:H6), roster cycle day ( range E1:H1) and the shift (C9:C12).
The result should be populated to sheet 1 range E9:H12.
My assumption in that the lookup function will need to be looped through a dynamic range of date.
Any help would be greatly appreciated as I have not been able to find/understand an example like this so far.
Thanks