asked on 7/13/2011

Tabbed sheets from a list

Hi experts,

I have a word sheet which was a pain to fill in so I have re-created it in excel tabbed "Template".
I want to add a list of users to a separate sheet, then using the "Template" create a sheet for each user, including their name in a field, say A3.

Is it possible and if so, please point me in the right direction.

Thanks
Andy

Microsoft Applications Microsoft Excel

Last Comment

Negativ3

8/4/2011

ASKER CERTIFIED SOLUTION

StephenJR

7/13/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Saqib Husain

7/14/2011

I would suggest that instead of making so many copies of the template you should just keep the template and work a way to change the name. This has the advantage that

- you can always change the template in only one place whenever required. You would not have to change all the generated sheets.

- you do not have to worry about having difficulty scrolling to the desired sheet

- troubleshooting/error checking is easier.

One way of changing the data in the template is to use a data validation list in the name cell.

Negativ3

7/17/2011

ASKER

Thanks guys,

Traveling at the moment so not had a chance to look at this for a few days.

StephenJR, will give the code a try. It's a macro, correct?

ssaqibh, not asking for spoon feeding here, but your concept sounds interesting. Anything on actual implementation?

Negativ3

7/30/2011

ASKER

Hello guys,

Back from my travels and am able to get this settled. Any feedback from my questions above will be answered by return.

Thanks
Andy

Negativ3

8/4/2011

ASKER

Just what I needed, thanks.