• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Custom filtering data basis multiple criteria and creating pivot automatically using vba. Need help.

A

aria

New Member
Hi,

Thanks to all for making me part of this intellectual team.
I have to manage and arrange data in huge volume and have to spend lot of time in custom filtering, replacing spelling mistakes in data manually to show it properly in pivot for all. For eg. Compleeeted to be corrected and written as completed. I have attached an excel sheet with input data and output format and steps are mentioned in it. Please help.
i tried doing it using macro and vba on my own but in between blank cells and unpridicatable range and lack of idea so could not do it.
I like this website and forum very much. This is my first post. If i made any mistake, please forgive me.....
 

Attachments

Hi Aria

Welcome to the Chandoo forum. I would stay away from VBA and use a fuzzy match with a list which you maintain. As new items come on you could add them to the list. I think 80-90% of your items you would trap in the first round if not all of them. This currently traps 100% see file.

Take care
Smallman
 

Attachments

Thanks for your prompt response. The formula that you have put in is working great however it still has manual touch required with that. i need a vba code help as its difficult to arrange 60000 range data using formula. its lot of manual work..i have been doing it so far..now need vba code to make it simple and quick......vba code to do following action - 1. Add a new column with name final subject. 2. Custom search data and mention relevant field item for that. 3. Action taken to be corrected and final step 4. To create a pivot as shown in pivot worksheet in above attached file.
 
Aria

Sometimes the best solution is the simpliest one and formulas in cells tend to work faster than VBA loops and the time it takes to write and maintain a procedure. In my opinion putting two formulas in 2 columns will largely beat creating a vba procedure to replicate this formula.

Take care

Smallman
 
Hi Smallman, Thanks for your valuable piece of advice however even than I would appreciate if someone can provide me vba code for the purpose mentioned above.
 
You must log in or register to reply here.
Back
Top