Complicated Clear Contents Loop with Numbering Function

I have a spreadsheet that requires a significant amount of reformatting every two weeks enabling utilization in another program for billing purposes. The ultimate output are invoices. I have two objectives:

The first is to clear contents of cells with duplicate unique identifiers. Column F in the attached sample spreadsheet is the unique identifier. For each subsequent row containing the same identifier, contents of cells in columns A through S are cleared. For example, If F4 = F3, then clearcontents of A4:S4. The following code was successful for the first; however, I have been unable to loop this for the entire worksheet. The master every two weeks is roughly 16,000 lines.

Please Login or Register  to view this content.

Upon execution of this macro, for each identifier, Column AA requires a renumber from 1 to 100, depending on how many lines exist for that particular identifier. For sample, in the sample attached, the above macro would clear the contents of A4 through S9. Subsequently, AA3 would hold "1", AA3 would hold "2", and so forth until the next unique identifier, which then begins the renumbering process.

Hi Alpha,

I didn't consider uploading before and after sheets, but duly noted for future posts. This worked perfectly and is probably the most complicated one I have had land in my lap. I spent a couple of days on this one trying to figure out how to loop the clearcontents piece.

Column AA requires a number on each line. As an example, Lines 4 through 25 would be numbered 2 through 23. I believe I can adjust accordingly. Your help is very much appreciated!!!