Macro to open file, filter data and copy to another workbook/sheets

Hi,

I'm about to create a macro to:
- open a file,
- if an input file was chosen open new workbook,
- create there three worksheets in that workbook, name the worksheets as Summary, A, B,
- in those created worksheets A and B paste the values from the input file with specific document type, either A or B,
- in worksheets summary create a small table with total amount for each document type,
- save the final workbook in the same folder with the macro.

I attached below two files, one with the sample input data (Input.xlsx) and the other (Output.xlsx) how the new workbook should looks like (three sheets: Summary, A and B and in Summary sheet a simple table with total amount.

Here I have the first part of the code and I got stuck in part with filtering the data :-/
So, so far the code is opening the input file (if file wasn't chosen it shows a MsgBox) and creating the new workbook with three sheets with proper names.

Please Login or Register  to view this content.

Any idea what further code should include?

Sorry for double post, but can anyone help me or at least give me some hint? :-)