I have two Workbooks. The first WB is a "Survey". The second WB is a Workbook where the imported data is analyzed. I want to import a single Survey into the second WB for analysis (so no consolidation is needed; only copying from one WB to another). The Survey WB will not change its name. The second WB name will change from time to time. For this reason, I think I need the macro to be in the second WB (vs. having an export routine in the Survey WB). The numerical Data is the only data that needs to be imported and I'd like to use "range names" to copy and paste to the other book. I would assume that both WBs are open when the import takes place.