Hi I'm trying to accomplish the following. I have a folder that contains 34 different shortcuts to workbooks that are all over the network. Each workbook has multiple sheets. Some sheets need to be excluded from the merged data but all the sheets that are to be merged are named differently but end with "Indicators" eg. "BS 442 Indicators". I need to copy range Q16:Q22 from each indicators sheet. I've managed to tweek Ron de Bruins code to get all the sheets to merge, but I can't filter out the non-indicator sheets. The RDBMerge add-in is not an option for me as it doesn't have .lnk as an option. Here's the code:
Please Login or Register  to view this content.