Filter multiple worksheets based on data input in a master works [Closed]

Registration date
Monday April 11, 2016
Last seen
May 17, 2016

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 2-6 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.


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!