Hi to all the experts,
I am facing stuck up problem. I am facing thousands records to edit. I think of using vba code to ease burden for data entry. I wonder if the vba code can allow me to find the specific keyword inside the job title. For example, I want to find multiple criteria for text like Talent or Staffing in column c, then hide their row or delete their rows.
hoping to learn alot of great stuffs here.
Cheers
Brad
Please Login or Register to view this content.Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by patel45; 09-17-2012 at 08:49 AM.
If solved remember to mark Thread as solved
Hi Patel,
Thank you for replying to my complicated question. IT is very helpful.
I am first timer here. Shall I copy all the 3 codes sets into my vba macro? It help me to delete for all the rows with my selected cell value - only 1 value - Talent. If i want to find both of Staffing & Talent or even more than 3 values (Staffing, Talent & Resourcing) to delete for their rows, is it possible how to do loop to find multiple value in column C to delete?
Many thanks!
Your request was vague, I attached some examples, there are many ways to achieve the same result
Hi, diaslag05,
you could use the Autofilter without any macros as well as to run through the list. Limitation to this is that itīs a continuous area of data.
And yes, you can have a list of items on a different sheet and work that from first item to last to find what you have searched for.
But after all it may also be a good idea to check out the Advanced filter where the headers for the data is copied twice as criteria range and as output. Each row will be an item to search for (no limitation like in standard Autofilter to only 2), and you could apply special needs like areas of postal codes to the criteria as well. The Advanced Filter needs to be started on the sheet where the criteria range and the destination is to be found.
Why do you want to delete the rows? I will usually make a smaller part of that list as I will work on it but keep the original in the same workbook.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks