Thread: Data check
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Matlack[_107_] Brian Matlack[_107_] is offline
external usenet poster
 
Posts: 1
Default Data check


Hi!
I would like to check, to see if the text in column "a" in this cod
exists in the range "data1" before proceeding on with the code. Thi
loop may involve several dozen rows only 3 or 4 of which will have dat
in column "k" but I want to verify that there is a valid name in colum
"a" of that row before copying the data to another range.
<start code
Sheets("sheet1").Select
For i = 1 To Cells(Rows.Count, "k").End(xlUp).Row
If Cells(i, "k").Value < "" Then
Cells(i, "n").Value = Cells(i, "a").Value
Cells(i, "o").Value = Cells(i, "b").Value
Cells(i, "p").Value = Cells(i, "c").Value
End If
Next i
<end code
Hope someone can help stear me in the right direction!!
Thanks for your time!

--
Brian Matlac
-----------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...nfo&userid=350
View this thread: http://www.excelforum.com/showthread.php?threadid=56121