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

Eric,

I think I know what your trying to do. Are you familiar with using the
{countif} formula. I believe using that may solve your problem without using
a macro. That is, unless you just need to know the address of the first cell
that deviates from the condition. If that is the case, you may be able to
still use {countif}, with another nested {if} statement. Let me know if this
helps. If not, please elaborate on what your desired result is.

"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

I don't know if the countif statement would work. Would like to use a macro
if possible. What I want to do is populate the entire sheet and after if
something changes on a design then change everything for the sheet from the
test on down.
IE:
If I have room for 400 rows or (tests) of info and each column has different
information. After test number 10 I need to change the information in column
"C" only. I want everything from row 11 (Test 11) to row 400 to be the same.
This will happen each time I need to make a change.

In this example everything from row 1 to 10 would be the same. Rows 11 to
400 would be the same. Does this help any?

Eric

"Lonpuz" wrote:

Eric,

I think I know what your trying to do. Are you familiar with using the
{countif} formula. I believe using that may solve your problem without using
a macro. That is, unless you just need to know the address of the first cell
that deviates from the condition. If that is the case, you may be able to
still use {countif}, with another nested {if} statement. Let me know if this
helps. If not, please elaborate on what your desired result is.

"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