Hi, i have this code which keeps the below sheets and deletes all other sheets, in the below statement i would like the code to copy and pastevalues for each of the below sheets, how can add this to the code
Code:
With ThisWorkbook
For Each WS In .Sheets
Select Case WS.Name
Case "Ratio", "Report", "Task"
Case Else: WS.Delete
End Select
Next