I have a table that looks like this:
B C D E F G H I J K L M
Vch V# Name Inv Date Due Amt Act Dpt Description Dist Batch

"Vch" is in cell B4 and the data starts on row 5.

The sheet is about 3000 rows tall and will grow to to
about 10000 by year end.
I need to extract (copy and paste/append to another
worksheet) a dynamic range that will change each week.
That range will be determined by the values in column G
(Due Date).
For example, this week, I have manually extracted the
following range (B1200:M2350 : all payments with a due
date equal to "08/23/04"

I need help with a macro that could do this, I think I
will be able to write the "append" part of the macro.