database to group

**mhax** · 07-09-2007, 02:30 PM

Hi,

I have a big database that has different name in column A(something like Y1, Y2, Y3, Y4, Y5, Y6, Y7, Y8...). What i'm trying to do is to group them! In group A i have Y1,Y7, in group B i have Y2,Y3, in group C i have Y4, Y6 and etc! I think the solution is something like index...but i never worked with that in VBA! So each name of group A should copy on a new sheet, the next rows should come group B and etc! Is there a way to do that in VBA??

Thanks

**mhax** · 07-09-2007, 05:15 PM

no one know how to do it?

**royUK** · 07-09-2007, 06:21 PM

I don't think anyone understands what you want. I certainly don't. What determines a group?

**mhax** · 07-10-2007, 08:38 AM

i thought i explained that. Well there is nothing that determine the group, so that's why i thought the solution would be to work with an index(in column A the names, in column B the group for each names). It looks like that : http://www.ozgrid.com/News/excel-subtotal-dynamic.htm(Grouping data onto individual sheets). But what i want is that the data go in order on the same sheet! Is that more clear?

**antoka05** · 07-10-2007, 09:29 AM

In the attached file there is an example of how you can group data... I hope it can help.

Regards,
Antonio

**mhax** · 07-10-2007, 10:03 AM

really nice, the code is nice too! but i've tried to make it works for what i have, and it didnt work! So i'm posting the file with the exact same sheet i have and that i need!

**mhax** · 07-10-2007, 10:18 AM

oh yeah about the zeros and blank, they have to appear on the sheet FinaL!

**antoka05** · 07-11-2007, 05:35 AM

In the attached file I added a command button in your 'Data' sheet.
The output goes in 'Final.' sheet.

Regards,
Antonio

**mhax** · 07-11-2007, 02:11 PM

big thank you to you!!!! it's really helping me! i'm trying to understand and to change your macro to fit what i have!! Maybe i will need your help again hehe :P! thanks again!
Maxime

**mhax** · 07-11-2007, 03:28 PM

the problem i have right now is that my groups are not numbers but names(ex: group 1 is called Orange, group 2 is called apple...)! So i get no values for mingroup and maxgroup. The second problem is that i have 3 values for each Date. I'm trying to find how to solve the problems!