ExcelBanter - scanning and grouping entire rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - scanning and grouping entire rows (https://www.excelbanter.com/excel-programming/319466-scanning-grouping-entire-rows.html)

nate44

scanning and grouping entire rows

how would I set something up to scan a spreadsheet's rows for certain
criteria and if that criteria is met within one of the rows cells, then
list/group that entire row?

Nick Hodge

scanning and grouping entire rows

Nate

Programmatically or via the UI, you would use DataFilterAutofilter

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"nate44" wrote in message
...
how would I set something up to scan a spreadsheet's rows for certain
criteria and if that criteria is met within one of the rows cells, then
list/group that entire row?

All times are GMT +1. The time now is 10:35 AM.