I need code to search for certain text, then delete the row, plus others. $30 REWARD

Here is what Im trying to do: I have a VERY large excel file (15,000+ lines) that has groups of text (this is all in one column)

I want excel to search for the cells with "UID" and delete that row plus every non-blank row above it. (so it deletes the entire "group") Here is example layout of what Im working with. The end result should be only "groups" without the text "UID" following it.

ExampleCell1
ExampleCell2
ExampleCell3
UID = example

ExampleCell1
ExampleCell2
ExampleCell3

ExampleCell1
ExampleCell2
ExampleCell3
UID = example

Now Im thinking this may be impossible, but I've seen some crazy things done with excel macros and was really hoping someone can help me out. Otherwise Im doing this manually for 15,000 lines of text.

Any suggestions are GREATLY appreciated!!!!!!!

I will gladly transfer $30 to the first person to solve this and has a PayPal account!

Are you able to upload a zipped version of the file?
Also are you wanting to keep a blank line between each group, or should they be removed as well?

Thanks

EDIT Also what is the EXACT format of the text in the UID cells? Is it "UID = " followed by some more text? (ie. are those spaces there? is the equality sign there?)

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

This should really be in the Commercial Exchange Forum

Unfortunately, I can not upload the actual file, It contains private company data.

And yes, the cell with the "UID" text will look exactly like [ UID: "some other text" ]
Its a colon, not an equal sign, I apologize.
UID: will always be at the beginning if thats what your hoping.

A blank line should be left between each group.

This should do it

Please Login or Register  to view this content.

This should do it:

Please Login or Register  to view this content.

A bit shorter option:

Please Login or Register  to view this content.

SOLVED! Thanks to RoyUK's code.

Phil_V, I couldnt get your code to run. I kept getting a "Run-Time Error 424" "Object Required" error.

RoyUK, my personal email is "[email protected]", email me your paypal account name and Ill send your $30.

Thanks to all who replied!!

Originally Posted by mainer188

Phil_V, I couldnt get your code to run. I kept getting a "Run-Time Error 424" "Object Required" error.

No idea why you would be getting that, it runs fine here everytime with the sample data you provided.
Anyhow for completeness here is my more condensed version:

Please Login or Register  to view this content.