Hi! I'm not the most Excel savvy and I need to get it to perform a function very often. Based on my research, it seems like a macro would be best bet for getting this done, but I have no idea what it would need to look like. I found the example on this page quite similar, I believe, to what I need... http://excel.tips.net/T002386_Condit...ting_Rows.html
But I don't know how to format it for my particular purposes. Would anyone be willing to draw this up for me??
1) IF cell G has ANY value
THEN delete the entire row
2) (This one seems complicated, so I wouldn't be too disappointed if it can't be done.)
IF cell B has ANY value
AND the value of cell F in that row EQUALS the SUM of column E, beginning with that row and ending at the next row in which cell B has ANY value
THEN delete ALL of those rows included in the equation
Example:
Original
wrkbkBEFORE.png
Editing process
wrkbkPROCESS.png
Results
wrkbkAFTER.png
Thanks so much for your assistance!
Bookmarks