ScatmanKyle
Board Regular
- Joined
- Oct 26, 2015
- Messages
- 65
- Office Version
- 365
- Platform
- Windows
I'm building out a macro to consolidate workbooks from a list. The list will have a boolean trigger indicating whether the workbook will be included (as below)
The issue is the WB codes are in cell A1 of the workbooks, not in the titles themselves, so I'm looking to store the values of all of the Yes options, then open each workbook. If A1 is included in the list of stored values, then it continues with the rest of the macro functions. Otherwise it skips to later in the macro where I have it close the file (already have this part written out). I'd also like it to return a message box after looping through all the workbooks indicating if any yes values were not used.
What's the best way to store the multiple WB codes, call upon them in a check for cell A1 of a book that's opened, then track whether it's been used and create a messageebox for any missing one?
WB Code | Include |
01 | Yes |
02 | No |
03 | No |
04 | Yes |
The issue is the WB codes are in cell A1 of the workbooks, not in the titles themselves, so I'm looking to store the values of all of the Yes options, then open each workbook. If A1 is included in the list of stored values, then it continues with the rest of the macro functions. Otherwise it skips to later in the macro where I have it close the file (already have this part written out). I'd also like it to return a message box after looping through all the workbooks indicating if any yes values were not used.
What's the best way to store the multiple WB codes, call upon them in a check for cell A1 of a book that's opened, then track whether it's been used and create a messageebox for any missing one?