Add rows if a cell meets a certain requirement

[JediKnight2]

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

 

[cdavis]

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.