Hi
when I use 'page_set' to duplicate page by criteria and export to excel the sheets name are page1 ,page2 etc
I want to give the sheet name by the duplication criteria (country or language)
is it possible?
and how?
10X
Hi
Have you solved it?
I have the same problem.
Thanks
you have to create a macro to do that.. I would assume there would be a reference that you can reference within the sheet itself.. it would be something like this:
Sub sve()
For i = 1 To Sheets.Count
Sheets(i).Name = Range("A" & i )
Next
End Sub