Forum Discussion
Messing up with a database...
Matteo-
What your asking can definitely be accomplished with VBA (macros). It will take a someone a fair amount of time to code you a solution. I would suggest posting your questions separately and building on the answers you receive. For example if you have 20 steps to get to your end result then separate them out in individual posts. If you do this you will get a better response. Its more likely that 20 people will take 10 minutes to answer your smaller steps then someone taking 200 minutes to complete your full project.
Here are some tips for posting questions on forums:
https://www.thespreadsheetguru.com/gethelp/?rq=Questions
That being said if you choose to use the alternative format you can make a simple refreshable pivot table to get to your "Ordered-Name" worksheet. (See Attached)