macro to name worksheets

[Eastshaw]

I'm developing a worksheet where there's a global report on 160 records, but also each record must have it's own report. How do I get the name of the worksheet for each record to match the name of the record.

eg for a survey - respondent 145 is called Joe Bloggs - I would like his worksheet to be named Joe Bloggs automatically when I create his separate sheet - as for the other 159 respondents in the group.

I have recorded a macro to create the sheet and copy in the common data which applies to each individual.

Many thanks,

Julie

[starryknight64]

Try something like this:

Please Login or Register  to view this content.

Of course, you're gonna have to change the worksheet name to the one you want.

I hope this helps!

[Eastshaw]

I'm developing a worksheet where there's a global report on 160 records, but also each record must have it's own report. How do I get the name of the worksheet for each record to match the name of the record.

eg for a survey - respondent 145 is called Joe Bloggs - I would like his worksheet to be named Joe Bloggs automatically when I create his separate sheet - as for the other 159 respondents in the group.

I have recorded a macro to create the sheet and copy in the common data which applies to each individual.

Many thanks,

Julie

Will do - many thanks!

Jules