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