I have several single-sheet workbooks with data in a folder that are labeled as
"XXXX-2013JUNE.xls"
"XXXX-2013JULY.xls"
"XXXX-2013AUGUST.xls"
....
I want to extract the value in B2 of those workbooks onto a new workbook that has the file name in column A and the corresponding extracted value in column B.
Is this something very simple to do?
Thank you, L
Bookmarks