Hi,

I've got a repetitive task I need to do thousands of times per year
which would be a superb candidate for a macro, but I'm trying to
figure out how.

Here is what I have to do.

I've got a range of data which starts with columns like the following:

<field 1 10/08/2007 <field 3 <field 4 <field 5 <field 6 $0.00
<more fields
<field 1 10/08/2007 <field 3 <field 4 <field 5 <field 6 $23.45
<more fields
<field 1 10/08/2007 <field 3 <field 4 <field 5 <field 6 $0.00
<more fields
<field 1 10/08/2007 <field 3 <field 4 <field 5 <field 6 $1.62
<more fields

The date field is important because it determines where in the target
table the rows get inserted and the currency field is important
because I don't want the nil ones.

I need to paste those values into another table in date order. The
target table consists of data in the above format, with varying
dates. The reason why the above all have the same date is because
each time I'm pasting rows into the main table, all those rows have
been extracted from a single payment statement. I'll always be
pasting one or more rows of data with a single date per batch.

What I do manually is I select the above rows, go to the table where
I'm supposed to paste them, scroll until I find the end of August
2007's payments and insert the rows then paste special (values only)
over the top at the end of the month. Then I select the rows with
$0.00 payments and delete them.

I'm ok with basic macro writing so I don't need to be told how to
automate copying and pasting as such, all I want to know is how I can
set the insertion point such that the insert/paste happens and how to
eliminate the rows with zero payment. Whether eliminating the zeros
is done before the copy or after doesn't matter.

Deleting the zero rows is the less important part of the problem, if I
could get an answer on the inserting at the right place part I'd be
happy.

Thanks in advance

Travis