IF N58 is “8 Week” and N64 is “7-19” and K31 is “CL1” then insert worksheet “8WK G7-19” rows 1 through 9 into worksheet “My Program” in rows 5 through 13
IF N58 is “8 Week” and N64 is “7-19” and K31 is “CL2” then insert worksheet “8WK G7-19” rows 10 through 18 ( Including row 10 and row 18 ) into worksheet “My Program” in rows 5 through 13
BUT
IF N58 is “8 Week” and N64 is “20-29” and K31 is “CL1” then insert worksheet “8WK G20-29” rows 1 through 9 into worksheet “My Program” in rows 5 through 13
IF N58 is “8 Week” and N64 is “20-29” and K31 is “CL2” then insert worksheet “8WK G20-29” rows 10 through 18 ( Including row 10 and row 18 ) into worksheet “My Program” in rows 5 through 13
This goes on and on but if you can give me the complete formula for the 4 scenarios above I can add in all the rest. Thank you SO much!!
Bookmarks