Hi,
I am working on a report which divides total income down to each consultant.
In a sum up page I sum up the total amount of income on different projects gathered from different pages in an Excel document. In addition, I want to add under each consultant a formula which fetch project number, project name, income of the project and total amount of hours spent on that project. Normally one could use a simple VLOOKUP-formula, but in this case the project numbers differ from each period. As do the name of the projects.
So - I was wondering if there is any formula or macros that could gather the correct project number and update the number of rows every time I change the period in the control cell? Meaning, if I enter 201508 (August 2015) in cell A1, the rows under each consultant should update with the projects where that specific consultant have worked in that specific time period. There should be one row for each Project.
Is there someone of you that have any suggestions to how I could solve this problem?![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I am working on a report which divides total income down to each consultant.
In a sum up page I sum up the total amount of income on different projects gathered from different pages in an Excel document. In addition, I want to add under each consultant a formula which fetch project number, project name, income of the project and total amount of hours spent on that project. Normally one could use a simple VLOOKUP-formula, but in this case the project numbers differ from each period. As do the name of the projects.
So - I was wondering if there is any formula or macros that could gather the correct project number and update the number of rows every time I change the period in the control cell? Meaning, if I enter 201508 (August 2015) in cell A1, the rows under each consultant should update with the projects where that specific consultant have worked in that specific time period. There should be one row for each Project.
Is there someone of you that have any suggestions to how I could solve this problem?