Try this.

Turn on the macro recorder.
Do an Autofilter on the table.
Select the due date you want.
Select Visible Cells -- This is the trick.
Copy.
now paste where you want.

Select Visible cells is found under Edit, Goto, Special Cells,

There is also a toolbar button you can put on a custom toolbar the is very
useful.
Right click a toolbar, Customize, Commands Tab, Edit, next to the last entry
on the right list.

See if that gets you close. I think it will be simplier than an Advanced
Filter or some several step OFFSET range.

Stephen Rasey
Houston
http://wiserways.com
http://excelsig.org


"Paul" wrote in message
...
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.