Excel VBA - read a WS and show results on another

[belblanco]

I need to loop through an array on one worksheet compiling some info an
show a summary on another. Could someone show me some sample code o
how I might do this... thanks

 

[Township of East Hanover]

http://www.erlandsendata.no/english/index.php?d=envbawbreadfromclosedwb

The above will show you how to get information from a closed workbook