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. For example:
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.
Brian
How familiar are you with VBA Macros? This sounds like a Worksheet_Change macro that monitors K15 and performs the Copy task based on the latest entry would work.
e.g.
Private Sub Worksheet_Change(ByVal Target As Range) 'Was change made to K15? If Target.Address = "$K$15" Then 'Clear old data Sheets("CU").Range("G6:G10").ClearContents 'Copy range based on value of K15 Select Case Target Case 110 Sheets("Code").Range("B2:B5").Copy _ Destination:=Sheets("CU").Range("G6:H9") Case 111 Sheets("Code").Range("B9:B13").Copy _ Destination:=Sheets("CU").Range("G6:H10") Case 112 'Etc. Case 113 'Etc End Select End If End Sub