• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 42
  • Last Modified:

Seperating true data in seperate sheet and false data in seperate sheet

See the sample file
Seperating true data in seperate sheet and false data in seperate sheet
I have to do all this by vba
Book.xlsx
0
Avinash Singh
Asked:
Avinash Singh
  • 2
1 Solution
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You may try something like this...

Sub SeparateData()
Dim wsData As Worksheet, wsBool As Worksheet, dws As Worksheet
Dim lr As Long, dlr As Long
Dim Rng As Range, Cell As Range

Application.ScreenUpdating = False

Set wsData = Sheets("Sheet1")
Set wsBool = Sheets("Sheet2")
Sheets("Sheet3").Cells.Clear
Sheets("Sheet4").Cells.Clear

lr = wsBool.Cells(Rows.Count, 1).End(xlUp).Row
Set Rng = wsBool.Range("A1:A" & lr)

For Each Cell In Rng
    If Cell.Value = True Then
        Set dws = Sheets("Sheet3")
    ElseIf Cell.Value = False Then
        Set dws = Sheets("Sheet4")
    End If
    
    If Not dws Is Nothing Then
        If dws.Range("A1").Value = "" Then
            dlr = 1
        Else
            dlr = dws.Range("A" & Rows.Count).End(3)(2).Row
        End If
        wsData.Rows(Cell.Row).Copy dws.Range("A" & dlr)
    End If
    Set dws = Nothing
Next Cell
Application.ScreenUpdating = True
End Sub

Open in new window

0
 
Avinash SinghAuthor Commented:
Thnx Neeraj sir for ur great support and thnx for giving ur precious time to this post
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Avinash!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now