Let me get some setup information from you first then; please answer the following questions...
1. Will the macro always look for its words to match in Column B, or could the column vary from file to file?
2. Will the macro always look in AU for the items to concatenate, or could the column vary from file to file?
3. You show the lookup and concatenate lists going from Row 3 to Row 6941. I am guessing the starting row will always be Row 3, but that last row seems strange. Will it always be 6941 or should the macro simply look for the last row with data in the lookup column?
4. What column should the output go to? Will it always be the same column for all the files you will use the macro against?
Bookmarks