I have this situation. I have two excel files, let's say, 1 and 2. I have a Key which is common in both the files with lot of blanks in the first file (never saw any primary key blank in my life). Let.s call it "Key Field".
I have a big dashboard with 20 worksheets. I need to join / blend for global filter. I only have two worksheets coming from second file, but the global filter is on the first file. All other data is mostly independent with no overlap.