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
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
Hi
It's already considering the shift. See these part of the code
Code:If Shift = "all" Then 'all CREATE_OUTPUT i, LB ElseIf Data(i, 2) = Shift Then 'match shift CREATE_OUTPUT i, LB End If
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Bookmarks