Aug 20 2020 07:25 AM - edited Aug 20 2020 08:10 PM
I have a spreadsheet that creates a table and copies hidden forms to their respective items as individual tabs, there are sometimes support forms which have been labeled with a connecting A-D. I would like the Table of Contents to sort column A items 10,10A,10B,10C,10D,20,20A,20B,20C,20D,30 and so on. I have tried bring the list from the "sorter" tab in through options but got cut off around 880A mark. I amended the SORT Macro but got a line continuation error. I am doing this sort for 10-5550 with possible A-D available for each. Any way to make this happen?