Ricky,

In the spreadsheet containing all the records, I would use the feature
"Autofilter" that you can find in the menu Data Filter Autofilter. First
select your range of records, with the first row being a header row, then
click on the menu Data Filter Autofilter. Some small down arrows appear
on the right of each cell of your first row. Click on the down arrow of the
cell containing the dates of the transactions, then select Custom. Enter the
beginning date and end date with the proper comparison, and click OK. Now,
you should only see the rows matching your selection criteria. Select the
whole set of rows (without the header row), and copy paste it to your second
document. Excel will only copy the visible rows. To see again all records,
select "All" with the down arrow, or menu Data Filter Show All.

Stephane