Macro to search column B in select sheets for value.

I was wondering how to go about writing a macro that would search a specific range of sheets (SheetX to SheetY) for a value that meets a criteria in column b. Then populate an array of the data from the row where column b is greater than a specified value.

excel help.PNG

For example, I want to search column B in all sheets for a value greater than 8000. The entry B33 meets that criteria. Then the entire row 33 would be put into an array on a "results" sheet.

Use an advanced filter …