Replacing information
 

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

Replacing information
 

Please re-think your requirements. What you are asking for is just to copy
row 1 to every row? Make each row the same. I think therre is additional
criteria that you have to post to specify which group of rows get copied and
which rows get over-written.

"Eric" wrote:

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