Creating Multiple Tabs From Data

Microsoft Excel 2003 (full product)
June 23, 2010 at 07:34:21
Specs: Windows Vista
Hoping someone might be able to help here.
I have a spreadsheet where I download about 20,000 lines with 16 columns, the 20,000 lines are made up of about 30 names all in column A.
Is there a way that for each name a new worksheet is created transferring all related data at the same time.

Thanks in advance

See More: Creating Multiple Tabs From Data

Report •

June 23, 2010 at 13:21:45
Look at Response # 2 of this thread. It appears to address a similiar request. Let us know if you need any more help.

Report •

June 24, 2010 at 05:57:48
Thank you ,I had looked at this but the first time I tried it was without success , However I have gone back to it and using the example managed to make it work for my problem.
Developing this a bit further is it possible that after the tabs have been created it could then automatically generate an email to the user and then attach the relavant tab ?.


Report •

June 24, 2010 at 06:10:21

Look at this post, response 7 and
this post.

Both create and send e-mails from Excel.

Note the warnings about the use of passwords in the code and potential security risks - less of an issue if you are not distributing the worksheet to anyone else.

Have a go with the concepts in these posts and post back if you need more specific advice.


Report •

Related Solutions

August 19, 2010 at 08:10:01
How can I get column 'C' below into separate tabs in a Excel single spreadsheet?

00 910009 FFX40120 100126 010627
00 910009 FFX40120 101598 000574
00 910015 FFX40041 101670 201004
00 910015 FFX40041 101670 201002
00 910900 FFX38800 UNK 005571
00 910029 FFX38000 100485 000703

Thanks for your help. Chevella 9195307124

Report •

August 19, 2010 at 08:28:47
Chevella - please post this as a new post.

When posting you will need to be more specific.

Explain the criteria for moving your data in column C
I presume you have one workbook and a several worksheets in it.

What are the Worksheet names
What is the relationship between the data in Column C and these worksheets.

Do you intend to have just one cell (a cell in column C) moved to a different worksheet - meaning that each worksheet only has one cell with data.

You also need to say what happens if you run a macro a second time - is data added to existing data, is the original data in the destination worksheets replaced.

To get a usable response you need to provide lots of detail.


Report •

Ask Question