Create a list on multiple criteria from a dynamic master sheet

[Dee Dee]

Hi,

I have a question that I am not sure if I am explaining right. I have a full database of information and I want to make a new sheet with a list off of that database carrying over three columns of information IF one other column in the database indicates Yes. I somehow cannot think of how to ask the question to be able to look for the answer. Any assistance would be appreciated. Clarification is probably needed I know.

 

[Fluff]

You have already asked this question in another thread, so you will need to stick with that thread. Thanks

 

[ouvay]

VBA solution:

Option Explicit

Sub DD()
    Dim s1 As Worksheet, s2 As Worksheet
    Dim i As Long, lr As Long, lr2 As Long
    Set s1 = Sheets("Sheet1")
    Set s2 = Sheets("Sheet2")
    lr = s1.Range("B" & Rows.Count).End(xlUp).Row
    Application.ScreenUpdating = False
    For i = 2 To lr
        If s1.Range("M" & i) = "y" Then    'Note VBA is case sensitive
            lr2 = s2.Range("A" & Rows.Count).End(xlUp).Row
            s1.Range("B" & i & ":E" & i).Copy
            s2.Range("A" & lr2 + 1).PasteSpecial xlPasteValues
        End If
    Next i
    Application.CutCopyMode = False
    Application.ScreenUpdating = True
    MsgBox "complete"

End Sub

Standard Module
How to install your new code
Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:
Press Alt-F8 to open the macro list
Select a macro in the list
Click the Run button

Worked well for me! and I had 6 criterias from different sheets in another workbook.. simple to read too!