Need to create a separate worksheet for each row of data

**gameplayer** · 09-01-2016, 06:45 PM

Hello,
I am using Office 2013 and Windows 10.

I have a spreadsheet with two sheets. One is called Worksheet and it's a template. The second is called Claim data and it holds all of the data. The number of rows is subject to change on the Claim data sheet and I need to create a new worksheet identical to Worksheet except I need to populate it with data from the Claim data sheet. I need one new Worksheet template or each row of data on the Claim data sheet. If I have 25 rows of data then I need twenty five copies of the Worksheet template with the data in each row being pulled into the new worksheet tab. Make sense?

I cant seem to upload the spreadsheet to this site so here are some pictures

Thanks in advance
claim data.png
worksheet.png

**noboffinme** · 09-02-2016, 07:53 AM

Hi gameplayer,

What about creating a Pivot Table from your first table?

What problems are you having posting the file?

Posting a file with dummy data that displays the problem is OK if you can.

**gameplayer** · 09-02-2016, 10:12 AM

Thanks for the reply. When I click on the Attachments button at this site, all I get is a very small window which appears and the option to upload isn't
there. I don't know why its behaving that way and I don't know how to fix it.

I was given this project as part of a job interview and while I like the pivot table idea she wants what she wants. Were you able to see the pictures here? They
don't appear as pictures for me, just two links which don't work

Thanks for any help

**noboffinme** · 09-02-2016, 11:35 PM

Hi,

To post an attachment, firstly go to 'Go Advanced' instead of 'Post Quick Reply' when you reply.

It may not be obvious that the file has uploaded, but as long as you Browse to it & then select Upload, you should see it uploaded in the 'Preview'.

**gameplayer** · 09-03-2016, 12:11 AM

Hello,
Ive already been to go advanced but all I get is a little window with NOTHING in it. I don't need directions for uploading. What I need is an answer to the problerm

**TheN** · 09-03-2016, 02:14 AM

Hi, there is a problem with the paperclip thing, it doesn't work. To actually attach something, scroll down to the bottom once you click go advanced, there you will find manage attachments, click on this. You need to browse twice, then click the upload button. It should then attach your file.

Nobody will be willing to help you if you talk the way you just did. We are helping you and you respond with this:

"I don't need directions for uploading. What I need is an answer to the problerm"

Quite frankly, that is quite rude. Also, seeing as how it is an assignment for an INTERVIEW, and you are asking others for help, you might want to re-evaluate the job. This requires VBA to do automatically, which is about all the advice I am willing to give you with the way you are asking for help.