Remove Row If Found Specific Value

Hi all,

I am currently creating a VBA macro that can help to read "specific value".

If found the "specific value", delete the whole row,
If not found "specific value", keep the whole row.

For example, you may see the files that I have attached. The main file is "All User Details" and subfiles ("User ID") are "13842", "43686" and "26698".

I want a macro that can read the "User ID" and find "specific values" like "pikol, hbkis, tgsdf" in "13842", "43686" and "26698".

Condition 1: If the "specific values" exists in the subfiles, delete the whole row from "All User Details".
Condition 2: If the "specific values" does not exist in the subfiles, remain the whole row from "All User Details".

There is an attached result file "All User Details (Result)", please have a look about it.

Do not hesitate to let me know if you have any enquiry.

Appreciate anyone who can help me in assisting to create this macro. Thank you in advance.

This assumes all the files incl. All User Detail in the same folder.
If not you need to adjust myDir,

Please Login or Register  to view this content.

It works well, thank you very much and have a nice day!

Hi, I found that I have this message when running this macro.

This message pop out for many many times.


How do I solve this? Thank you.


Attachment 802999

Your attachement is invalid so can not open.

Originally Posted by jindon

Your attachement is invalid so can not open.

It shows "Microsoft excel is waiting for another application to complete an OLE action".

That's nothing to do with the code.

If the workgook is not in your local drive, move it to local drive and see how it goes.

I see.

Since I am converting pdf to Excel subfiles ("User ID") and then read the Excel file. Is it possible to read the pdf instead of Excel file to do the same thing.?
How should the code be changed?

Thank you.

You are now asking completely different question.

Open a new thread and explain EXACT situation that you are now.

Hi jindon,

I have posted a new thread in my profile. I can't post the link here. Please check it out in my profile.

Appreciate if there is any macro that can help with. Thank you very much.