here what i got! :

A B C
1
2 1
3
4
5
6
7 2
8
9
10

I need a macro that will transform it to look like this! :

A B C
1
1440
2 1
3
4
5
6
1440
1440
7 2
8
9
10

So the macro will search in column C, and if there is a value 0 i
will insert new lines corresponding on the number he found in a C cel
(if C7=2, will insert two rows upward). After that i need the macro t
put the values 1440 in B cell of the new row inserted!

thanks

--
mha
-----------------------------------------------------------------------
mhax's Profile: http://www.excelforum.com/member.php...fo&userid=3645
View this thread: http://www.excelforum.com/showthread.php?threadid=56302