Hello good people!
I have made a form for bird population used as reference to our result program. We have seen that it is a problem for people to deliver a useful list of birds and this make us use/waste a lot of time to sort things out when we update this with our result-program. So I have am trying to make a form to eliminate the problem. I have translated my form to English as best I can.
My problem is a macro that sort multiple sets of columns in a certain way. It is possible to edit in all cells in the columns in the form. The sorting must be in a certain way, like this ; 1. A/U, 2.Year, 3.Ringnr., 4.Club. And like this in all 3 sets of columns. (A means male and U means hen).
I need the sorting to be in a way that wherever the member write the information of his birds in the form, it is sorted and eventually moved to the left set of columns, when that is full it continues to the middle set of columns and then the right set of columns. And at the same time also sorted as described over with 1., 2. etc. The sorting is done whenever the member press the button "Sorting". I have also made a keyboard shortcut for the same function, Ctrl+s.
I have made a macro that works well in the left column, but I am not able to make it work with all three sets of columns as I need to. Whatever I try out in my macro it fails. I am out of ideas and knowledge.
I would appreciate help with this. If anything is unclear I am at your disposal.
I send as attachment the whole file, translated to English and unlocked. There is formulas in some cells and I guess you will see that. I case if the macro did not follow the file, I have copied it in the word-file.
Sub Sorter.docxPigeon population Form 2.xlsm