I have to use VBA. The only problem with doing it the way you suggeste
is that the cell it is looking for contains both numbers and text so
can't use = to capture cells. Also, I wont know an acutal locating o
where the sum formula will be placed because it is going to find
specific entry, insert a row, then place the sum formulas for eac
column in the appropriate place. Any more advice?

Thanks so much,
Adriann

--
Adresmit
-----------------------------------------------------------------------
Adresmith's Profile: http://www.excelforum.com/member.php...nfo&userid=913
View this thread: http://www.excelforum.com/showthread.php?threadid=27373