I require an excel function that can do the following.
Scan a sheet that I specifiy in the VBA in code an filter the data currently sheet by looking through specific columns that I specify and criteria that I can specify. For example:
Sheet = DataSheet
Column A = >1000
Column C - Must Contain the following string ("google")
Column E <> 12345 Or 54321
Column F = "marketshare"
The rows that meet that criteria are to removed from the datasheet.
Please keep function as generic as possible will would like to use filter through multiple datasheets all of have varing amounts of columns.
Commenting would be cool, cya.