Sort rows and maintain order with second grouped column: Help a nonprofit brother out

Hello

I need some help making a list for a museum I volunteer at. With my limited excel knowledge I am trying to make a sortable list of donors each with unique grouped fields. I have them grouped so they could be collapsed to make overall viewing easier but If I try to sort them alphabetically I cannot figure out how to link Column B so the fields stay with the sorted column A. I looked around and some similar problems had been sorted via a pivot table or VBA but those days have passed for me and am in need of some assistance.

I put a small sample of what I am going towards. Is there a way to sort column 1 and have the rows in column 2 stay with what should be their parent in column 1. Thanks

FoundationInfo.xlsx

Not quite sure what you have in mind since I don't see a list of donors, but have you tried putting hidden text in the relevant rows in Column A? In your example, it would say "Toyota USA Foundation in cells A3 through A6 but these would not display. Then, if you sorted on Column A, the rows would stay together.

If this doesn't work, try adding to your sample file but, obviously, use dummy data.

Sorry yeah read my post again and is a bit confusing. Basically if I want to sort alphabetically, column A (foundations), my objective is to have the groups in column B (grant information) move as a group, following the foundation where ever it goes. Reasoning is so when more are added and thus sorted (A-Z) all of the information stays with the foundation.

Reasoning for having groups for the info was to simplify searching and browsing when column B is collapsed. Right now when you sort A-Z column A Column B no longer corresponds. I have done something similar in Access before using a join command or the likes, but I am trying to keep this simple, at least for the front end user.

Is what I am after possible?

Let's see if the attached work for you.

Jindon,Hm I tried the attached file and on my end it appears the same as the file that I posted.

Here is screenshot:ExcelScreenshot.jpg

When sorting Column A (A-Z) the only change is that 'SIA Foundation' moves from A2 to A6. The second spreadsheet labeled data but it appears blank. What am I missing, could you upload how it looks on your end maybe something is not translating correctly your version to mine.

That's strange.

When I run the code, it will post the result in "result" sheet correctly.

No idea.

Here's the code

Please Login or Register  to view this content.

Thank You! I think there is an issue with the Excel on my laptop, I am now getting a licensing error when I run the macro... Going to try tomorrow morning on a different computer and will post of my hopeful success.