rename shet in multi sheet excel report

[BenziD]

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

[g.congnos]

Hi
Have you solved it?

I have the same problem.

Thanks

[msalice1]

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