Hello all,
I am trying to have a macro count the number of lines down if it doesn't
match the last line.
ie:
Date c1 c2 c3
11/8 10 20 30
11/8 10 20 30
11/8 10 20 30
11/8 10 20 30

If I have 4 rows of info and the new date is now 11/9 it won't match row 4
but I want it to count down from row one to row three and replace the
information on rows three and four. If I had to count down two rows then row
three and four would have the date and info as follows:

ie: (Go down 2 row)
Date c1 c2 c3
11/8 10 20 30
11/8 10 20 30
11/9 20 30 40
11/9 20 30 40

This would carrie on for 400 rows. I hope this makes sense. If not I will
try to explain again.

Eric