Auto Filtering all additional Sheets based on one cell value in Sheet 1

billbalint33

New Member
Joined
May 23, 2017
Messages
3
I am looking for VBA code that will filter 30+ Excel tables starting with Sheet2.

Each sheet will contain a table with a date range in column A starting with the header row being row 1.

I am looking to enter a date into Sheet1 in cell B2. I'd like to add a Command Button to Sheet 1 to run the code that would filter every remaining sheet to that date based on the date entered into Sheet1, B2.

Thanks for the Help!
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,102,305
Messages
5,486,072
Members
407,531
Latest member
WalterR01

This Week's Hot Topics

Top