Add/remove names in project (IF-Function)

Hi

With respect you are making the same mistake that I see time and time again. You are mixing up the two elements of data capture and final reporting. The two require quite different treatments.

A lot of people start by designing the form that they expect to see as the final report or which at first glance seems the best way of capturing data, and then wonder why it's so difficult to subsequently analyse and summarise or extract information from it. Yours exhibits all those features.

You should always capture data in a simple two dimensional table and worry about reporting information from it afterwards. Without exception doing this you will always be able to easily obtain management information. Rarely is this the case if you start the other way round.
You will also throw open the whole wonderful world of the powerful Pivot table functionality.

So, and if your company is at all serious about this, before you get too far you should create a single sheet database that contains the following columns

Date
Name '*
Function '*
Project No. '*

The * values could be Validation drop down cells from which you could pick values. The way I normally arrange these things is to have a single data entry row above the database in which the new values are entered, then a button which runs a macro that adds the new record to the database.

See the attached.
I've added three sheets. A data sheet, a variables sheet where you would maintain staff and project names and a pivot table
To add data use the 4 cells at the top and click the button above. The new record will get added to the data.

The Pivot Table is just one view at the moment. However since it's a PT you can pivot it to show other relationships

Dear Richard,

First and foremost, I can't thank you enough my dear friend! I really appreciate you and your time, also for the very nice example you attached. It makes things so much easier for me.

I have some questions which hopefully will make this easier for me to understand. My question is and I would really appreciate it if you could show me step by step, with screenshots maybe, how you did the "Click to add information" in the data tab, I know you used "Assign Macro" and developer, but what commands did you put in. Thanks in advance :D

Also, for instance, a person can maxium work 40 hours per week in a project (which should be shown in green, if this person works less than 40 hours week it should be shown in yellow), if they were to work more than 40 hours, it should show in the color red. How do I create this?

Once again dear Richard, I thank you with all my soul! You deserve nothing but the best!

Best and dearest regards!

Sia :D

Lastly,

I really like your Pivot Table. How do I add for instance, week 1 January Alex Pav will work 2 hours, week 2 January AP will work 5 hours and so fort. In other words, I try to delegate the amount of hours per week. Lastly, how do I create a sheet that shows:

Project 1 has 5 people working on it with total 100 hours? So that this info keeps updating whenever I add new people and so forth?

Thanks in advance, and wish you all the best!

Sia :D

PLS, anyone help me out!

I would greatly appreciate if anyone could help me out please.

I have a pivot table, sheet name "pivot table", and then I have a sheet name, "data", where I fill out the persons name, project name and then at the top "Klicka här för att lägga..." is just a macro command. As you fill out the information and then click on the box, the information will appear below in the table, and the pivot table. In addition, I have added information at the sheet name, "pivot table" to the right of it, you can see information of every week of the month from januari week 1 2017 to 2018. The numbers are stating total number of hours which are references and summurization of hours from each week, this derives from sheet names "1", "2", and "3" and so forth.

My question is, when I fill out information, in the sheet name "data", how can i make automatically that I will show up in "sheet" pivot table, and similiar references i made, but instead show up automatically. I tried with "show report filter pages" which will show every project in its own sheet, but how do I manage to make it show up like that automatically when I fill out information in the sheet name "data"?
Best regards

SIA