I need to improve a medium size data base in which the same article could have many differently written names by grouping these articles in new groups and would like to use VBA macro for this excersice. I have roughly 50 different article names which need to be grouped into 10 new names. I tried to solve it by using vlookup-functions and it works, but the file size explodes....
I have attached a small sample data base including the article names and the new group names.
Last edited by Gustav; 11-24-2010 at 08:49 AM. Reason: Edited attachment - added before and after
Add your desired results in an AFTER page on that sample workbook.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I have edited the attachment in the sample workbook. Thank you!
Please Login or Register to view this content.
Thank you snb, your code worked excellent for my sample set.
My problem is that there are some blank (empty) cells in my full data set (I should have included blank cells in my sample, sorry). I have attached a new sample.
Please Login or Register to view this content.
Thank you snb, it works perfectly. I just have a last question..... If the "article" column would be #20 (insted of #1) and the new column would be #36 (insted of #7 (6)), how do I need to change the code? Thank you for your brillant help!
Best regards
Gustav
Please Login or Register to view this content.
Thank you snb, your help was great!
New file attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks