Our vendor sends us a report which they put into EXCEL. It contains headers and a lot of extraneous information.
I've got a macro writtenn to sort the file so that all my policy info is grouped together, but in the process, I would like to write a macro to get rid of the rows when the following conditions apply to cell A1:
A1 = Blank
A1 = Agent:
Could I get some help with that?
I've got a macro writtenn to sort the file so that all my policy info is grouped together, but in the process, I would like to write a macro to get rid of the rows when the following conditions apply to cell A1:
A1 = Blank
A1 = Agent:
Could I get some help with that?
