each macros you provided works fine alone. now if you can kind o
combine both to do the following: i need for it to enter the last tw
right digits of the cell containing the lease type into each subsequen
row until it finds the next lease type. it then continues the proces
through all the lease types

--
acarri
-----------------------------------------------------------------------
acarril's Profile: http://www.excelforum.com/member.php...fo&userid=1002
View this thread: http://www.excelforum.com/showthread.php?threadid=26204