Hi,
I have a workbook with multiple worksheets within it. For each sheet I want to filter based on the contents of one column but need the filter to work like the search autofilter i.e. to filter based on the contents of the cell containing any part of the term not the whole. An example of this would be I want it to include cells that contain car so not only would cells containing car return but also carrier, cart, carbon etc.
Then once that filter has been applied I want to determine the median value of a different column and output this either into the same worksheet or another. This all needs to be done across multiple (200+) worksheets.
Any thoughts on a code that could do this?
Thanks
I have a workbook with multiple worksheets within it. For each sheet I want to filter based on the contents of one column but need the filter to work like the search autofilter i.e. to filter based on the contents of the cell containing any part of the term not the whole. An example of this would be I want it to include cells that contain car so not only would cells containing car return but also carrier, cart, carbon etc.
Then once that filter has been applied I want to determine the median value of a different column and output this either into the same worksheet or another. This all needs to be done across multiple (200+) worksheets.
Any thoughts on a code that could do this?
Thanks
