Copy / Paste macro
 

Hello,

I am trying to automate the following process and am wondering if anyone
could help me with creating a macro to accomlish the following:

Search a column (i.e F), which consists of only date entries in form
mm/dd/yy hh:mm, and filter in all entries which match last month (current
month -1). Then cut those entries, open file called bc-log.xls and paste
them starting at row 2, saving changes to both files.

There can be anywhere from 10 to 50 entries that the filter would match....
the number of previous month entries always varies.

Thank you,
Luke Slotwinski