Automate and Print Reports through VBA

[waleed#]

Hi everyone. I would like to use VBA to create a report ("Report" sheet) as per attached "Report_template" file that sources its contents as follows:

1. Name and address of intended recipient from "Registry" sheet
2. For each of "Fund A" and "Fund B" and based on a quarter, identify all transactions (i.e. "Issue" and "Redeem") that fall under the quarter in "Fund A" and "Fund B" sheets for the recipient in (1) above, copy the relevant rows and paste them in the applicable section in sheet "Report".

In addition, there should be a drop down list representing all members and the report shall be generated based on the member selected from the list and the quarter selected.

Finally, I would also like to put a button that when clicked prints the records that I selected (I have created the button in the "Report" sheet).

I would appreciate anyone's help to write the necessary VBA code for this initiative. For info, I am quite new to the VBA code.

Thanks in advance