Ok...Is there a way to add a row everywhere a cell in A has an entry
of ENDTRNS...so basically something that can run down Column A and
where there is an entry of ENDTRNS add a complete row above it. What
I really need to do is run through column A and add a copied row above
the ENDTRNS row...