I need to add fields with (something like) VLOOKUP across specified worksheets
- or -
Post a project like this2149
$80
- Posted:
- Proposals: 14
- Remote
- #2014077
- PRE-FUNDED
- Awarded
Data Entry Operator, Word, Excel Expert | Fillable PDF Form | Edit PDF | Audio Editer
Colombo
Excel VBA, MS PRoject Expert, Web Scraper, Arena, Simulation, Spreadsheet, Wordpress customisation
Istanbul
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
14494731281565715266498656945761237383130044914064161480623212146521821432212952
Description
Experience Level: Expert
Estimated project duration: 1 day or less
A subset of the worksheets in my workbook have rows of persons and columns of month names; the values of the cells are manually entered integers, corresponding to hours worked in a month by a person. Each worksheet is a specific project.
These worksheets are named after the projects; a registry of them is maintained as a column in a separate Registry worksheet.
I have another worksheet I want to use to add up all the worked hours per person, across all projects. Not every person is listed in every project. This worksheet looks like a project worksheet (month by person) but adds up values of the named worksheets.
I need to be able to define projects simply by adding a named worksheet and registering it in the Registry worksheet. The summary worksheet should automatically pick it up.
Persons added into the summary worksheet should have their column values automatically calculated by checking the Registered worksheets to see if the person is listed in them.
Attached is a skeleton worksheet showing the basic structure. Note that only the values in the PeopleListN sheets should be considered; the NotPeopleList should be ignored.
These worksheets are named after the projects; a registry of them is maintained as a column in a separate Registry worksheet.
I have another worksheet I want to use to add up all the worked hours per person, across all projects. Not every person is listed in every project. This worksheet looks like a project worksheet (month by person) but adds up values of the named worksheets.
I need to be able to define projects simply by adding a named worksheet and registering it in the Registry worksheet. The summary worksheet should automatically pick it up.
Persons added into the summary worksheet should have their column values automatically calculated by checking the Registered worksheets to see if the person is listed in them.
Attached is a skeleton worksheet showing the basic structure. Note that only the values in the PeopleListN sheets should be considered; the NotPeopleList should be ignored.
Steve N.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
33%
Last project
21 May 2018
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies