Macro to copy rows from the data sheet to existing worksheet

[terence8]

Hello Everyone,

I'm new to Macro writing and have found this forum to be helpful and an invaluable aid.

I have two worksheets.
Worksheet 1 is a large data sheet containing columns of data (Date, State, Payment Method, etc, etc)
Worksheet 2 is the 'Report' worksheet with 2 blank cells (A1 and A2) for users to manually enter the Start and End dates, a drop-list for State names (B1) and a drop-list for Payment Method (C1) - Cash or Credit Card.

How can I write a macro to:
1) Filter by Start and End Dates then,
2) Filter by State name then,
3) Filter by Cash or Credit Card then,
4) Copy these filtered records (i.e. whole row/s) onto the 'Report' worksheet starting at Column A, Row 5.
5) Macro to end with a 'Successful' message.

Thanking you.

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.