Recording Macro that deletes remaining columns

[shawnnai]

I am trying to record a macro that leaves me with only those rows that I wish to work with. The sample I'm attaching has been dummied to only 100 rows, but my real worksheet has around 25,000 rows and 76 columns at any given time. What I'm trying to accomplish overall is this:

Delete all rows that have a blank in column C: Docs to County.
Delete all rows that have "Electronic Transmission" in column D: Tracking Number
Delete all rows that have a blank in column E: Docs Received from County.
Delete all rows that have a blank in column F: Recorded Date.

I'm fairly inexperienced, so I've been trying to record a macro that would get to the end result as if I were filtering the spreadsheet myself, which would be filter down to the blanks in each column and then delete all of the remaining rows, but this doesn't seem to work when recording a macro because I have too many continuous something... I don't remember the exact wording from the error I received. I'd welcome any feedback or further recommendations for streamlining this process.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[shawnnai]

Thank you - I plugged this in exactly as it is, but I got a bug here:
Range(Cells(2, i), Cells(x, i)).SpecialCells(4).EntireRow.Delete

[rcm]

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Can you provide a sample sheet with some dummy data which produces the error? BTW what does the error say?

[JOHN H. DAVIS]

Sorry I misread your requirements.

Please Login or Register  to view this content.

[shawnnai]

@rcm - This is great! Except I think I asked incorrectly the first time. I want to delete all rows with blanks from Column C and KEEP all rows with blanks for Columns E & F, so what do I enter for the value to delete everything EXCEPT blanks for those?

[shawnnai]

@John H Davis - when I ran this last code on my spreadsheet, the report returned with 7 rows, four of which show a Tracking Number "Electronic Transmission."

[JOHN H. DAVIS]

@John H Davis - when I ran this last code on my spreadsheet, the report returned with 7 rows, four of which show a Tracking Number "Electronic Transmission."

Note: the code was edited at 3:19 EST. your test file has "ElectronicTransmission". Also what I found is when I tried to meet your requirements there were no rows?

[shawnnai]

Note: the code was edited at 3:19 EST. your test file has "ElectronicTransmission". Also what I found is when I tried to meet your requirements there were no rows?

Yes - I put them in incorrectly. What I do actually need is:
Delete all rows that have a blank in column C: Docs to County.
Delete all rows that have "ElectronicTransmission" in column D: Tracking Number
Delete all rows that DO NOT have a blank in column E: Docs Received from County.
Delete all rows that DO NOT have a blank in column F: Recorded Date.