Ok came up with a little problem? If in the event there is a need for another Time Log in the Report, the Sort button doesn't Work? I tried manipulating the code to allow for a Variable of the word "Time Log*" but I cant figure it out.
So if there is one Tab named "Time Log" and then you need another one, the second one is called "Time Log (1)" I need it to be able to sort that second page as well.
Like the code I have below that will count how many Tabs in the workbook are Named "Time Log"
'Count of Time Logs in report
For i = 1 To Worksheets.Count
If Worksheets(i).Name Like "Time Log*" Then
Ctimelog = Ctimelog + 1
End If
Next i
Worksheets("Table of Contents").Range("I13").Value = Ctimelog
Bookmarks