K KathyJean Mar 27, 2008 #1 I want to search multiple files for the same cell, and have the information in that cell (i.e. c2) transferred to a new worksheet.
I want to search multiple files for the same cell, and have the information in that cell (i.e. c2) transferred to a new worksheet.
D Dave Peterson Mar 27, 2008 #2 Ron de Bruin has lots of sample code. I'd start here: http://www.rondebruin.nl/tips.htm