Create new sheet for each row and include header

S

Sabosis

Hello-

I have a worksheet with the title rows in rows 1-3. Below that are the
rows of indivual statistics for employees, usually 10 rows but could
be anywhere between 8-12. I was looking to add code that would create
a new sheet for each employee, have the title rows on each new page,
then in row four, the stats each employee on their page. Also, the
employees name is in column A on the main worksheet (A4, A5, A6,etc).
When the new page is created, the employees name would be in A4 below
the title rows. Can the value of A4 be used as the sheetname for each
sheet created?

Thanks in advance for any help provided....
 
D

Don Guillett

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top