ExcelBanter - Creating new worksheets using data from a single sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Creating new worksheets using data from a single sheet (https://www.excelbanter.com/excel-worksheet-functions/201519-creating-new-worksheets-using-data-single-sheet.html)

Ryan N

Creating new worksheets using data from a single sheet

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

Creating new worksheets using data from a single sheet

This can be done with VBA. You may want to post something to the Programming
group and see if they can help.
--
HTH,
Barb Reinhardt

"Ryan N" wrote:

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

Ryan N[_2_]

Creating new worksheets using data from a single sheet

I am not very familiart with VBA, any help?

"Barb Reinhardt" wrote:

This can be done with VBA. You may want to post something to the Programming
group and see if they can help.
--
HTH,
Barb Reinhardt

"Ryan N" wrote:

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

All times are GMT +1. The time now is 01:22 AM.