Auto-Populate new rows on separate tab based off "Master" tab

[JBMS]

First of all, I only know enough about excel to make myself think something is possible, then work on it for hours on end and usually give up.

I have a "Master Resume List" spreadsheet with 400+ names. As we receive resumes, we add them to this list. It has all sorts of information in separate columns like years of experience, city/state, certifications, etc.

Here's what im trying to do:
I want to add another column to the "Master" called "Current Project". If that person is currently working for us, it will contain the project name (via a drop down list). Then, I want to have a separate tab for each project that automatically lists everyone from the "Master" list that is working on that project (basically building a roster for each project). In addition to the name, we need 2 other columns from the master - phone number and email address.

I know absolutely nothing about macros and VBA code - can this be done with a formula? If not, I was hoping someone could walk me through the macro/VBA process. Thank you in advance!

[FDibbins]

Hi and welcome to the forum

I think the attached is what you want?

[JBMS]

Exactly what I wanted! Maybe one day I can be the one to answer peoples questions... Cant thank you enough for the help and quick response!

[FDibbins]

Glad it worked for you

Will you be having lots of project sheet?

[JBMS]

It will vary. Currently I will have 8 but we have been as high as about 30 in the past. Some projects last a matter of weeks, others years. I will add/subtract project tabs as they come & go.

I will just have to create a new tab for each new project and copy the formulas, correct? I may be asking for a little much here - but is there a way that it can recognize a new project name on the master and automatically create a new tab? For example, your spreadsheet has 4 "projects": aa, bb, cc & dd. If I were to add project ee, can it automatically create an "ee" tab with the list of names?

What you have already done is perfect, it will work great. If it will get too complicated, not sure if I would want to go there...

[FDibbins]

Yup, 1st, create the new sheet, then click just above 1 and to the left of A, to select the entire worksheet (saves fiddling with scrolling down and right, and also maintains column widths and formatting), press CTRL C (copy), click on A1 in the new sheet, press CTRL V (paste) and change the sheet name in the cell containing the sheet name. If you really want, I could make it so that the sheet name auto-populates as well?

To create a new tab will require VBA - not my strong suite

Edit: to have excel put the sheet name in F1 (or wherever that ended up for you), paste this in that cell...
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

[JBMS]

I would like to stay away from VBA myself. That stuff is rocket science to me. Besides, if/when I pass this on to someone else, it needs to be something others will understand.

After messing with your spreadsheet some more, I have found that if I just copy the tab (by right-clicking the tab at the bottom), then change the project name in cell F1 to the new project, its as simple as that!

I feel confident that I can take this and expand/adapt it to my needs exactly. Again, I appreciate your help.