|I want to check the value in worksheet "make ready" cell K15 for values from 110 to 122 and go get data from worksheet "codes" depending on value.|
If Worksheet "Make Ready" cell K15 = 110 then copy cells from worksheet "Codes" Cells B2:B5 to worksheet CU G6:H9.
If worksheet 'Make Ready" cell K15 is not = to 110 check for 111 and so on up to 122.
If worksheet "Make Ready" cell K15 = 111 then copy cells from worksheet "Codes" cells B9:B13 to worksheet "CU" G6:H10.
Sounds like a complex operation but I think it can work.
Send me any questions if I wasn't clear.
Thank you in advance.