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...

Yes there is a way! First I would suggest that you
manually try a few rows while recording a macro. Then
look at the generated code. Modify this code to get what
you want.
If you are not familar enough with VBA then I could write
this for you, but I normally get paid to do that type of
work.
-----Original Message-----
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...
.