Hi MrExcel,
I created a generic userform which can work with multiple worksheets.
I have a macro in a module that will execute some code to export the sheet to another workbook. (i.e. macro name = Export_BOM_CostSummary() , or Export_BOM_PcsPc() etc.)
The sheet that I want to export has a...