PDA

View Full Version : Need to VBA Grouping for 2500 Rows.



dunkin
11-14-2016, 07:20 AM
How Can I grouping for large amount rows?
I can not group manually, this file has too many rows also I need to ungroup them. ?
is Macro dashboard work for this file.
Please look in to Attached File.
Thanks.
Note: This is Classified Info, So I had to Encrypt this file.

p45cal
11-14-2016, 07:54 AM
Group by what?

dunkin
11-14-2016, 08:13 AM
Group By Rows. If this has duplicate value.

p45cal
11-14-2016, 08:41 AM
What?!

Which column does the data need to be grouped by?!

dunkin
11-14-2016, 08:51 AM
Columns A,B and C Group By Zip Code

p45cal
11-14-2016, 09:13 AM
In the attached, see new sheet with pivot table.
On sheet1 is a button where you can create another new sheet and pivot.

snb
11-14-2016, 09:16 AM
This is my encrypted answer:

p45cal
11-14-2016, 09:18 AM
This is my encrypted answer:LOL

Aussiebear
11-17-2016, 07:07 PM
@ dunkin After reviewing your thread, I can see where those members who responded have gone with this. I fully realise that this issue is important to you and with that in mind, might I suggest a couple of things to help improve any assistance offered in the future.

a) Putting Classified data onto an open forum, whether its encrypted or not is like inviting potential hackers to a free go at your data. I urge you not to do so.

b) Most people are reluctant to open files from people they do not know. To gain their confidence, you need to present an accurate description of the issue and what you are seeking. In this case I would have suggested " I need to group columns A,B & C by rows, (if they have a duplicate value), in the initial post. I strongly suspect that the responses would be better.

c) Respond to replies. You were provided a solution in post #6, but as of yet you have not indicated if this meet your expectations. If so could you please mark the thread as solved by using the Thread Tools dropdown, or if it hasn't please indicate what it doesn't do correctly.