Is there a way using a macro to check each row in Column D and Column F for "0", so that when both columns in the same row have "0" and only when both columns in the same row have "0" the contents "0" in that row of Column D and F will be deleted?
Is there a way using a macro to check each row in Column D and Column F for "0", so that when both columns in the same row have "0" and only when both columns in the same row have "0" the contents "0" in that row of Column D and F will be deleted?
Last edited by EJensen; 05-15-2009 at 04:21 PM.
You might be able to sort on columns D and F and block delete the rows you don't want, depends what order the data is in
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
I actually need to do the same thing with column E and F but I can not resort the sheet because I would not be able to get back to the original sort and that can not be changed. Is there a way to do this by macro?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks