I have Excel 2010. I need a Macro that will search all of the cells for specific data, and then delete every cell containing the data.
- Example -
Search every cell for "abuse" and delete every cell that has abuse
and then
Search every cell for " .ru " and delete every cell that has .ru
and so on and so forth
I attached the complete list of things we need searched for and deleted. I will also need to be shown how to add additional words to the list.
This should be a very simple project for any macro writer out there.
Consider it done. Check my past reviews for your reference. I can do this job in 1-2 hour. Eagerly waiting for your reply. I can create a small macro with 2 sheets. First sheet will be your input file and second is where the data will be checked. Once you click run the macro will do its job.
Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I have lots of experiences in excel formatting and automation. I will make a macro for you with a message box to input your criteria to be searched and deleted. or we can assign a list like the list you provided and delete them by one click. I am looking forward to hear from you. I CAN MAKE A DEMO FOR FREE AND IF YOU WERE HAPPY THEN WILL GO ON. Regards.
Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more. Mentioned below are a few USPs for choosing me:
1. Well written codes with proper documentation
2. Highest possible code optimization
3. Quick support through email / skype / telephone
4. Daily / Weekly status reporting
Let's discuss and make this project a success.
Regards,
Hardik Shah
Hi, I can help with this, experienced VB programmer. The macro will need to read your list and go through the excel separately for each entry of your list. After that, if you add more entries to your txt, you just have to run the macro again.