I have a sheet with financial transactions on it, with columns for date, amount, description of the charge, etc etc. Each row is a separate transaction. This sheet auto-updates (not my code) with my transactions, so eventually at the end of the year it will have transactions from 1/1 through 12/31.

On another sheet, I would like to extract all the transactions (data points) from the first range that fall into a given period between two dates, and pull the row data into a new range for some manipulation. Preferably, I could define the dates that bound the data I want dynamically in a few cells on the second sheet.

So if I had 10 transactions a month for 12 months on Sheet1, I would want to go to Sheet2, enter a start data and an end date (say 1/1/2015 and 3/15/2015), and have all the transaction data between those two dates from Sheet1 infill below. Basically a filter on the first data range on Sheet1, except it would appear on Sheet2 (or 3, 4, 5, etc). Because the data on Sheet1 is basically my "master set" and I cannot screw anything up on it, I want to leave it untouched.

Thoughts on the best/cleanest way to do this?