Would you like me to take this up ?.
I think I can do this.
Thank you ! I will start working on it.
Please attach the excel file or send me the link to download it.
Coding is almost done. Doing some testing of it.
Please download your template using below link :-
I have made minor modification in your template as per the my macro's coding. I tried to delete sample data and it is working fine for me. You can try the same with some sample data and let me know if you find any problem in it.
Once you are satisfied, then you can provide me your valuable rating and bless me. Feel free to let me know if you have any questions or concerns.
Okay. I will use the same excel file.
Regarding issue with highlight, You may have to click on enable editing and open this sheet in your machine in edit mode.
I will update your template as it is and get back to you.
Please check out this one.
I am using the same excel which you have sent to me. Please send me the screenshot of your screen. I will be able to figure out the problem.
The excel file which I have sent to you is macro enabled and is having .xlsm extension. You need to download it first to your desktop and press yes/I agree whenever you receive a pop-up while opening it and then you need to click on enable editing button on the top of screen so that you can edit it and use it in your desktop.
If dropbox is not working fine for you then here is the direct link : -
Yes, It will take some time to finish as we have lots of rows to compare. You can multiply column B and Column E to see the number of matching this macro will be performing to get the result.
After matching it deletes cells and shifts the below cells up so that you do not see any empty cell in between. It also preserves your column E so that you get to know how many /which all data you deleted.
For testing you can use couple of records in column E and see if it is working as expected.
Regarding, Dropbox I wasn't knowing that you are using drop box for the first time. Macro enabled files(.xlsm) can not be shareed using JustAnswer's page that's the reason every expert use other medium to share files.
oh, what a coincidence. I was about to tell you the same thing .
I tired multiple times , It is working for me. Can you tell me for which records it is not working for you ?
If you want to send any file to me and you can use http://wikisend.com/
I can call you if you wish.
Please accept the premium service offer so that I can call you. As per site's policy we can not connect until customer opt for premium service. I have kept the price as low as possible.
Thank you . I will call you in a min.
I called to this number but some said it is wrong number.
OK. Give me a min
After pressing delete button did you get message saying your task is now complete or no matching records found etc ?
Yes, I can see there is a problem . I am fixing it.
Please use this link, I fixed a bug in it :-
Thank you !. Yes, While testing those were deleted.
Let me know if you have anything for me anytime. You can see my contact information below.
Hi William. Sorry I missed you on this question. Let me know if you have any more and I'm happy to help. --Steve