Hello, I have information that is being taken from another workbook and being pasted into the main sheet using VBA. I would like to clear contents of all of the rows over to column G, based on a numerical value being found in column G. Column H and I have formulas. If the cell in column G is blank I would like to keep all of those rows. Any help you can offer would be awesome! Thank you in advance.