Hi everyone,
First post here. Excited to read and learn some new things I can put to use. Have been searching for a few weeks and tried a few macros but can't seem to string it all together for a recent analysis I'm trying to accomplish. Any help or ideas are greatly appreciated!
Case
- Within a folder new Excels are added daily which contain new information including two columns which I'm specifically interested in which are called "Lif #" and "Tin #"
- I'm looking for a macro or any method that would search all of these Excels and look for those two specific columns that could be in each Excel workbook which could also have multiple worksheets
- Output would be a new worksheet that lists the results of all the searches and all rows with the columns "Lif #" and "Tin #"
- I could then use the results to do a concatenation of the "Lif #" and "TIN #" to create a unique key, then use this key as a lookup against a master list to see if the results are found or missing against the master list (unless this could also be automated somehow and missing lines highlighted).
- The format of the Excels can change, depending on the condition. One Excel will have these two values in specific columns but another Excel could have them in two different columns
I've found a few macros that allow searching just for the one string I can do, but I haven't been able to tie them together to get a complete anlaysis with results returned like the above.
Thanks again!
- J
Bookmarks