Macro to scan whole workbook to find % greater than 20.

[outlawdevil]

Anyone knows what can I do if I want to run a scan to every cell and generate a report to say where the percentage is greater than 20%? Noted , this spreadsheet contains various text strings numbers. I just thought it will be really cool to pick that out rather going through them to identify it. Thanks

 

[venkat1926]

in the absence of all the particulars it is difficult to give a solution. however try autofilter-custom. see help

if necessary post a very small extract of data and explain what you require.