sleepy_think
05-15-2008, 02:53 PM
Heya folks,
problem:
I have a "checklist" worksheet and a "data" worksheet. I need to take a value in the checklist worksheet (located on range("b2")) search the data sheet in range from ("k11:k5693") for the match up, then copy the range that finds that data from column c to k (but only that particular row no others).
heres what i have so far:
Dim usid As String
Set usid = Range("b2")
Range("C2").Select
Workbooks.Open Filename:="x:\data.xls"
Dim DATS As Range, Mycell As Range
DATS = Range("K11:K5693")
For Each Mycell In DATS
With Mycell
Select Case True
Case .Value = usid
End Select
End With
Next Mycell
thanks in advance!
problem:
I have a "checklist" worksheet and a "data" worksheet. I need to take a value in the checklist worksheet (located on range("b2")) search the data sheet in range from ("k11:k5693") for the match up, then copy the range that finds that data from column c to k (but only that particular row no others).
heres what i have so far:
Dim usid As String
Set usid = Range("b2")
Range("C2").Select
Workbooks.Open Filename:="x:\data.xls"
Dim DATS As Range, Mycell As Range
DATS = Range("K11:K5693")
For Each Mycell In DATS
With Mycell
Select Case True
Case .Value = usid
End Select
End With
Next Mycell
thanks in advance!