Hello,
I have a listing of movies that have genre details. Some are essentially the same but in different order. I have table slicers that I can select one of these but because some are in different orders there is redundant entries.
Can these be arranged in alphabetical orders? The Movie sheet is where the table resides and updates the information from the Data sheet by clicking on the 'Refresh' shape. Maybe there has to be a helper sheet?
Thank you for your assistance.
Is this a VBA question?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Yes you are right it should be VBA. There is code in place so maybe it could be altered for arranging the column in order.
Could you please move the post to VBA?
Last edited by billy60; 06-02-2023 at 08:53 AM.
Thread moved.
Thank you kindly
Can there be VBA that sorts the Genre column of the table in A / B /C / D / E / F / G order? However many types of genres keep them in this order. Maybe the Refresh code can have this ability as it pulls the data?
Thank you very much for your help
Column Data From:
B / A / F
A / D / T
C / F / G / D / A
TO THIS:
A / B / F
A / D / T
A / C / D / F / G
Last edited by billy60; 06-03-2023 at 05:17 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks