Filter multiple worksheets based on data input in a master worksheet.

**tina16marie** · 05-18-2016, 09:44 AM

Hi,

I need some help with creating a VBA. I have a workbook that contains 6 worksheets. The first worksheet is a summary of the data listed in the 5 other worksheet by month. Worksheet 1-5 has a column that contains data by month and the summary worksheet has a cell (B1) that will allow me to input the numerical month I would like to filter worksheet 1-5 by. Can someone help me with creating a VBA that will allow me to filter data in worksheet 1-5 on Column E based on the numerical month I input the cell B1 of the summary tab? I added a link to the sample workbook I created.

https://www.dropbox.com/s/wtlqsmw0yc...lter.xlsx?dl=0

Thanks

**AlphaFrog** · 05-18-2016, 01:19 PM

Sub Filter_Sheets()
    Dim ws As Worksheet
    For Each ws In Sheets(Array("Worksheet 1", "Worksheet 2", "Worksheet 3", "Worksheet 4", "Worksheet 5"))
        If ws.FilterMode Then ws.ShowAllData
        ws.Range("A12:G12").End(xlDown).AutoFilter Field:=5, Criteria1:=Format(Sheets("Summary").Range("B1").Value, "00")
    Next ws
End Sub

**tina16marie** · 05-18-2016, 04:46 PM

Thanks AlphaFrog! That worked

Filter multiple worksheets based on data input in a master worksheet.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Filter multiple worksheets based on data input in a master worksheet.

Re: Filter multiple worksheets based on data input in a master worksheet.

Re: Filter multiple worksheets based on data input in a master worksheet.

Thread Information

Users Browsing this Thread

Similar Threads

Copying data from multiple worksheets to a master worksheet

Move row data automaticall from master worksheet to specific worksheets based on cell data

Split data into multiple worksheets based upon a column in master worksheet

Accumulating data from multiple worksheets into a master worksheet

autofill data to multiple worksheets from master worksheet?

One filter/ Master filter multiple pivot tables based on worksheet...

How To Populate Data From Multiple Worksheets To A Master Worksheet

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions