Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete Row Containing "x" in ColumnA in 2 Worksheets | Excel Discussion (Misc queries) | |||
I can't delete a cell without deleting a row | Excel Discussion (Misc queries) | |||
how do I delete a worksheet from my workbook | New Users to Excel | |||
Delete row depending on criteria | Excel Discussion (Misc queries) | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions |