View Single Post
  #1   Report Post  
Hulkascooby
 
Posts: n/a
Default 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?