Dear Excel forum members
I would like to take this opportunity and thank you all for your competence.
I am a novice in Excel and still learning.
Now to my dilema:
I have attached an Excel file, called "Lena" were I have a created a pivot table through some help with some help from Richard. This can be found in sheet name "pivot table". The data which can be seen on that page dervies from sheetname "data". From sheet name "data" with some help, I did macro record, if you look at the top (Cell B3, C3, D3 etc), "Name, project Name, hours" you can fill out information in these cells (The names of people comes from a sheet name called "variable"), when you are done, you can click at the top "Click here to add information". Once you do this, that new information will be populated below and at the same time be seen on the sheet name "Pivot Table".
When you are at the Pivot table, to the right, you can see month and each week, for instance January 2017 week 1, 2 and so forth. Under each week I made a formula of total amounts of hours spent in a certain project, this information can be found in sheet name "1" which is project name IKEA (cell A5).
My question is, when I fill out information in sheet name "data", I want it to automatically create a new sheet, a sheet name with that project name (from data sheet) and the people involved in that project as you can see in sheet name 1 which i manually created. Then at the same time, the amount of hours filled in this sheet, should be automatically shown and summarized in the sheet name, "pivot table"just as I have done manually. Please, I really need your assistance and help.
Thank you so much for your help and time, I greatly appreciate it
Best regards,
Lena
Bookmarks