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.
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.
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.
Last edited by Richard Buttrey; 08-08-2013 at 06:14 PM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
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.
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
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.
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.
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:
P.S. doesnt add the heading row wrote a seperate macro to do tht.Please Login or Register to view this content.
Last edited by arlu1201; 08-09-2013 at 01:49 PM.
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.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks