VBA Code to Select/Import Worksheet From a Workbook

[Fieldsdj]

I need help excel gurus...

Here is my situation: I have a workbook called "AFE MTP_4SOS.xlsm" and one called "Export.xlsm". I need a macro that will run from "AFE MTP_4SOS" and import a worksheet from "Export". So the macro will need to open "Export" and show a list of all the available worksheets and let the user choose which one to import. Once the user chooses, that worksheet should then be imported after the last tab in "AFE MTP_4SOS" and then deleted from the "Export" workbook.

Thank you in advance for your assistance.

 

[cerfani]

no prob... try to make something simple with forms when you are bored and as you learn the mechanics of forms it gets easy