The Excel gods have not been smiling on me this evening. I can’t get two different worksheets merged the way I want to, which is without requiring my users having to do anything other than click “Refresh all Queries.” It isn’t working. Poor data quality seems to be the culprit.
Read other posts