Hi,
I'm trying to automate the process of pulling data from a certain range (not all data) from around 6-7 other excel files into one master document. It would be great if I could filter the documents based on their title (i.e. they are all dated, so if I set it so that the program would search for the current date in all the titles, and pull very specific data sets into the master copy). All the documents are formatted using the same template.
Any help would be appreciated, as I am a n00b when it comes to programming.
Thanks.