If Then for cell value automatically delete row [closed]
Here's what I want, I haven't found a way to make it possible...
A1 is references a list of 2 items on sheet 2, the items being "0" and "delete" cell A2 has the following code: If A1 = "delete" then Delete Row ...So that the row (not necessarily row "1", but a relative row... whichever row has the above code in it and the cell to the left of the cell with the code has "delete" in it...which is cells A1 and A2 in the above example)
Sorry if i'm repetitive and lame, I just really need to find the solution to this.
@Anonymous I'm sure it's possible, but you'll need to know how to write Macros first.
I think you should explain this with more details; I am pretty good with Calc but I am having trouble to understand what you are trying to do... or I should keep reading until it gets clear in my head :)