ExcelBanter - How do I search a data range for a particular value then collate .

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I search a data range for a particular value then collate . (https://www.excelbanter.com/excel-discussion-misc-queries/4179-how-do-i-search-data-range-particular-value-then-collate.html)

Hulkascooby

How do I search a data range for a particular value then collate .

How do I search multiple worksheets for data contianing a certain value and
collate it into one. Also allowing it to updat automatically when the source
sheets are updated?

All times are GMT +1. The time now is 05:43 AM.