Add rows if a cell meets a certain requirement

  • Thread starter Thread starter JediKnight2
  • Start date Start date
J

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