Dear All,
I am writing in this forum to seek help from all of you . I am quite new to macros and have little understanding except for copy pasting the code into the developer tab.
I need some help with deleting all rows in an excel file except for 3 strings provided by the user.
All the information is available in column A of my excel spreadsheet which as about 80K records.
Column A contains customer names and some customers are known a little differently. For example Customer Name, Customer.Name, Customer Name Inc etc. This is all text.
So, the requirement is for a macro code as below :
1. Provide a input box or any other way to capture the user inputs. The user should be able to provide 3 inputs separated by comma
2. Once the inputs are provided, the code runs and finds all inputs in column A of the spreadsheet and deletes ALL rows EXCEPT for the rows which match the inputs provided by the user. The first row has the headers show it should be retained.
3. Code needs to be fast knowing that the excel file has about 80 K records to look out for .
You may suggest that I should use the filter, but that is what I have been doing so far. The problem with using the filter is that I may not be using the file always. It could be someone else who isn't well versed with filters and excel. So any automation efforts will help.
Thank you everyone for your help in advance.
Bookmarks