OK I want to delete cells in a spreadsheet based on the contents of Column B
I am gonna word it out
so you can understand:
I want to delete all rows in a spreadsheet that contain no data in column B, as long as the
data in column A is not "Cookies", or "Salt". The range of cells I want to delete spams from "A7:G7". when deleting this I
want to shift the cells up because there is data beyond column "G" that I want to maintain.
After the cells are
deleted I will have to restore my formula(s) down until "B200:I200"
Also there is a conditional formatting rule to
shade every other row that always gets messed up, I would like it restored to cover the Range "A7:I200" (Note Columns H and I
are hidden) The formula I am using is " =MOD(ROW(),2)=1"
Then I will reset the print area.
post started here. But I cannot get it to work. Fresh ideas will be more than welcome.
Here is my sample Delete
Empty rows (3).xls
Thanks a lot