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
Try this:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks