Take row headings and make a new sheet for each

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roxanne - 30 Sep 2004 22:14 GMT

I have a list of employees that I want to track uniform issue. I woul
like to take each row and make a sheet for it, but I don't want to d
it one by one, by hand. Is there some short cut to make a sheet fo
each row? Thanks for your help,
Roxanne :

Reply to this Message

Earl Kiosterud - 01 Oct 2004 03:01 GMT

Roxanne,

It could be done, but would require a macro. Consider carefully doing that,
as there is virtually no capability for working across sheets for sorting,
finding, summarizing in various ways. Read more at
www.smokeylake.com/excel/excel_truths.htm. Read "Data across multiple
tables." Think about what you'll be doing with the data.

Signature

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

> I have a list of employees that I want to track uniform issue. I would
> like to take each row and make a sheet for it, but I don't want to do
> it one by one, by hand. Is there some short cut to make a sheet for
> each row? Thanks for your help,
> Roxanne :)

Reply to this Message