Hi Guys,
Basically I have check boxes in an input sheet tab and whatever selection is ticked it will list them in the current order on the output tab.
Formula im using is:
=IFERROR(INDEX(Input!$B$10:$C$22,SMALL(IF(Input!$B$10:$C$22=TRUE,ROW(Input!$B$10:$B$22)-ROW(Input!$B$10)+1),ROWS(Input!$A$1:$A1)),2),"")
Now what i need if possible a macro set up determining the sequence of the selection. There can be a number of different sequences based on the selection so I just need a code im able to edit.
Example if 2, 5, and 1 is selected. Sequence should state 5,1 and 2 in the output tab.
Please find attached spreadsheet.
Any help is greatly appreciated.
Thanks
Bookmarks