Win 7 Pro
Excel 2007
I have about 150 workbooks in a folder on a server and need to pull a specific value from a cell ("O1") in each of these workbooks. This cell is on the same worksheet in each workbook ("Main").
The workbook that I'm trying to pull the value into has the names of each of...