Delete if "X"
 

Hello I need some help... I need a way to delete a entire row if the value in
Column A is equal to "X", the tricky thing is this... the purpose is to have
a "Main Sheet" where I have some data and I type those "X"'s into Column A,
and thru Formulas or Codes to get those "X"'s into other sheet's Column A in
the way that when I run the code I delete the same row in those sheets at the
same time. I had some code that did a similar thing but with "Blank" rows the
problem was that on the other sheets where the "Blank" was given with a
formula (IF formula), that row wasn't deleted because it contained a formula,
which had gave nothing but still had a formula.

What I need doesn't need to work in the same exact way with the "X"'s and so
on, so anyway in which I can delete the same row in several sheets is
appreciated!

thanks in advance!

Delete if "X"
 

You can sort by Column A, and delete all the rows with column A = X


"Ed" wrote in message
...
Hello I need some help... I need a way to delete a entire row if the value
in
Column A is equal to "X", the tricky thing is this... the purpose is to
have
a "Main Sheet" where I have some data and I type those "X"'s into Column
A,
and thru Formulas or Codes to get those "X"'s into other sheet's Column A
in
the way that when I run the code I delete the same row in those sheets at
the
same time. I had some code that did a similar thing but with "Blank" rows
the
problem was that on the other sheets where the "Blank" was given with a
formula (IF formula), that row wasn't deleted because it contained a
formula,
which had gave nothing but still had a formula.

What I need doesn't need to work in the same exact way with the "X"'s and
so
on, so anyway in which I can delete the same row in several sheets is
appreciated!

thanks in advance!