button to generate data selected "above" into a new workbook

hello there,

i have created a MACRO and i just need the "Generate" button at the bottom to be able to pull the data which the user has selected above, filter it according to certain fields from the workbook and the result to be shown in a new workbook.

The user will have to select 3 files but the generated workbook(new) must only have 2 sheets containing data from the first file into the first worksheet and from the second file and third file combined into the second sheet of the new workbook.

Attached to this is my current MACRO so please help me on this.


thank you so very much


regards

sam

Originally Posted by peterjuhnke

hello sam
I think this is what you want.
Regards
Peter

there is nothing in there bro. i think you uploaded the file without the coding.

i need the "generate" button in the macro to filter the files selected earlier by the user and to display it in a new workbook.


please help.


regards


sam