Hi,
I have about 40 workbooks and I want to automatically look through the last sheet of each workbook in the folder and pull out information for all REL duties and display the following in a new workbook:
Name
Date
RELnn (nn being the number)
I've attached an example sheet and highlighted in red the information i would expect the macro to find.
Is this possible for excel to do or is it too complicated?
Jimmy
Bookmarks