I'm new to learning this VBA stuff & I have taken over a project. This is where I am stuck.
I composed and if statement in TAB "COL Schedule" Column x right now is where I was successfully able to get my IF statement to go in & result in Column X "Day 1" if my planning day was Day 1.
Problem is when I added an Else, to try to put in planningday=2, 3,4,5,6...etc, it gave me a compile error. So I erased it. So issue one is how do I get the If statement to move down with each new copy & paste (written in the code) to Columns Q~ W (the data is resorted (Columns G ~ M)each run in my "for" statement and then the top ranking item is copied and pasted into column Q).
Second issue is how to complete my Else and match the "Day 1,2,3" to the planning days... I can probably figure this out later if I can get one successful "Day 1" assigned to each planningday = 1 line.test Schedule.xlsm