Excel VBA macro to make sheets

Closed
IngridH - May 20, 2010 at 02:47 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 20, 2010 at 06:47 AM
Hello,
I'm looking for a macro that makes a sheet in the Excel-workbook.
I have a mastersheet with all the persons working in a company in a particular job (in column A) and I have as many template-sheets as there are jobs. The link between the master and the other sheets is the name of the job, always in cell D5. If the job is found in the mastersheet the name of the person (in column B) is placed in cell D1.
Now I'm looking for a macro that makes a new sheet for every time a certain job is found in the mastersheet. So if the mastersheet has 5 times job A, the macro makes 5 sheets; if there are 10 times job B, it makes 10 new sheets. All in the same workbook. The new sheets can have the name sheetA(2), the next sheetA(3) etc. or have the name of the person.
At the end I want to have as many sheets in this workbook as there are persons in the company.


1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 20, 2010 at 06:47 AM
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.
1