Formulas in linking worksheets

  • Thread starter Thread starter Kristal_81
  • Start date Start date
K

Kristal_81

I am creating a new database...I am wondering if someone can help me figure
out the formula that if I want to copy all the rows that contain "suzanne" in
the column C or go one further and have "suzanne" in Column C and have "open"
in column D. At this point I will only be linking between worksheets not
files.

My Email is (e-mail address removed)

Thanks For your Help!
 
for rw = 2 to range("C1").End(xlDown).Row
if cells(rw,"C")="Suzanne" AND cells(rw,"D")="OPEN" then
rows(rw).COPY
' paste it somewhere
index =index + 1
sheet2.Rows(indes).PasteSpecial xlValues
'
end if

next
 
Back
Top