Hi,
First of all please forgive me my English.
I have some sheet named for example ("CZLON"), as below. It contains some data imported from the txt files or created manually:
czlon.jpg
I need that data to be sorted in specific way:
First priority, by column "E" ( if cell contains text with "S355" - it is first than "S235" - second)
Second, by column "D".
There is much more than 255 items in list so the standard excel sorting is not working properly.
I`ve created something like this (forgive me if something is wrong, I`m total VBA amateur):
In point of fact it is working but it is not comfortable for the other users to put some new data in custom list directly in VBA code (the list of items is not constant).
So I want to create a new sheet with the list of items. Their order tells excel how to sort data in sheet "CZLON" (or some other).
Something like this below but with much more items that user can modify:
lista.jpg
Is this even possible? Can you please help me with it?
I`ll be grateful for any help.
Bookmarks