Creating new worksheets using data from a single worksheet

[Ryan N]

I have a worksheet that has 50 rows of data on it and I wanted to create
seperate sheets for each row of data. Is there an easy way to do this or do
I have to create 50 seperate sheets and copy the data over?
Please help, this could take me days.
Ryan

 

[Barb Reinhardt]

I have several questions before code can be created:

* What worksheet do you want to copy from?
* Where is the data that you want copied. Does it start in row 2 column 1
and continue from there?
* Do you want a specific worksheet name and is it contained in one column
of the data? Are the names unique?
* Do you want headers copied to each sheet and where are they currently
located.
* When complete, do you want to delete the original sheet?

It'll be a while before I'm back, but answers to these questions may help
someone else.

Barb Reinhardt