We have several hundred Excel files within a single folder directory on our network. We are looking for a way to search through each of those excel files knowing that the phrase "Source:" is at the end of data for each spreadsheet located in Column A. We need to pull out all of the source data that comes after/below where Source: is located in column A for each spreadsheet in directory. Thanks in advance for any help with this.
Regards
Regards