copy information from one sheet based on valu

September 14, 2010 at 06:15:24
Specs: Windows 7, core i7, 6GB RAM
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


See More: copy information from one sheet based on valu

Report •

#1
September 14, 2010 at 13:31:16
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


Report •
Related Solutions


Ask Question