list

Question

Hi all, my first post and i know you can help me. I have 20+ single page excel sheets which are not in any particular order but i would like to put them in the order i want. Not alphabetically. How is this done please.

I use a Dell PC windows 10

I am using professional plus 2016

Thank you

Paul Lynch

hansvogelaar · Answer

japlyn5355gmailcom&nbsp;
I'd just drag the sheet tabs to the position where you want them. Writing and testing a macro for this purpose would probably cost more time...

juliano-petrukio · Answer

japlyn5355gmailcom&nbsp;&nbsp;WelcomeConsidering you have a Main worksheet where you list is saved (sort order list).Sub SortSheetUsingAList()
    Dim i As Long
  
    With Sheets("Main")
        For i = .Range("A" &amp; .Rows.Count).End(xlUp).Row To 1 Step -1
            Sheets(.Cells(i, 1).Value).Move Before:=Sheets(1)
        Next i
    End With
  
End Sub&nbsp;Find attachment.&nbsp;

Forum Discussion

list

2 Replies

Resources