automatically creating sheets from information in one sheet.

[fshadow]

i have a list of names with multiple columns that has different information about each individual. i wanted to make each person there own sheet without having to manually create sheets and copying and pasting it.

[Richard Buttrey]

Hi

You could create a master template sheet then right click the sheet tab name and use the Move or Copy option and select the copy option.

However carefully consider whether a separate sheet for each individual is your best way forward. What information will you eventually want to report from your workbook? I see so many workbooks like your suggested approach where individual sheets have been created for different people/weeks/departments etc., and then the users find it extremely difficult if not impossible to summarise or report across all sheets.

I would seriously consider keeping all your data on a single sheet and add an extra column in which you record the individuals' names. Then continue to add new records in this single sheet. You'll then find reporting so much easier and will open up the whole world of the powerful Pivot Table functionality.

[stanleydgromjr]

fshadow,

Welcome to the Excel Forum.

To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data changed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.

[fshadow]

Thank you Richard for your answer, however that does not really save me any steps. Yes pivot tables are great to view all my data but i need to create individual profile pages.

[Richard Buttrey]

Hi,

I didn't say it will save you any steps as far as data entry is concerned since obviously you need to record data somewhere be that in a single table or in many tables (on individual sheets).

However don't reject my suggestion out of hand since if you ever need to analyse or summarise your data a single table will be much more efficient. Even at the trivial level if you have a single dedicated column with the individual's names on a single sheet a simple data filter using the name column will show you exactly what you would see if you'd entered the data on a separate tab for that person.

Believe me I've seen this pre-occupation with separate sheets leading to difficulties in reporting later on too many times.

[fshadow]

Again Richard thank you for your time, your suggestion was noted and that is how my data is always stored and viewed. I had a task to complete a certain way and wanted a quick way to do it. Anyways i solved my own problem:

Visual Basic:

Please Login or Register  to view this content.

P.S. doesnt add the heading row wrote a seperate macro to do tht.

[arlu1201]

fshadow,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.