Re: Linking worksheets, but exceptions

Tech-Archive recommends: Speed Up your PC by fixing your registry

Thanks for the help. I am not sure how to run macros, but a friend is going
to try and help me. I may email back for some macros help later. Thank you
for the help.

"Otto Moehrbach" wrote:

Emily
This little macro will do that for you. I assumed that your main ***
was named "Main". This macro will copy the row and put it in the proper
contractors *** if Column J IS NOT EQUAL TO "N/A=do not audit" and Column
V IS NOT EQUAL TO "No" and Column K IS EQUAL TO "Active". Post back if you
need more. HTH Otto
Sub ParseData()
Dim rColA As Range
Dim i As Range
Sheets("Main").Select
Set rColA = Range("A2", Range("A" & Rows.Count).End(xlUp))
For Each i In rColA
If Cells(i.Row, 11) = "Active" And _
UCase(Cells(i.Row, 10)) <> "N/A=DO NOT AUDIT" And _
UCase(Cells(i.Row, 22)) <> "NO" Then
With Sheets(Cells(i.Row, 16).Value)
i.Resize(, 23).Copy
.Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial
xlPasteValues
End With
End If
Next i
End Sub



"Emily" <Emily@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:535E74F8-476D-4D06-81A1-9D308170D900@xxxxxxxxxxxxxxxx
I have a work*** with columns A - W. Column P contains names of a
contractor. I want 7 more worksheets named the contractor names ( I can
do
that), but I only want their information on that chart. Also, I only want
the information if Column K=Active, Column J does not have "N/A=do not
audit", or if Column V=no. Please help.

Thanks in advance,


.

Quantcast