D
dipti.agrawal
Hi, Anyone there who can help....
I have an XL sheet with 3 sheets
1) Sheet1 - contains a dump of data from database containing the tim
report of each employee in the organisation. This data is dumped on
weely basis. The demographics of the data is such that an employee ca
be working on more than one project and will be charging his time spen
to more than one project. Thus, each employee may have more than on
row of data for a particular week.
2)Sheet 2 has a list of employees I am intertested in --- I don't wan
all the employee
3)Sheet 3 - this is the sheet which I need to populate with th
information -- Logic required here is
i) Lookup all the names from Sheet 2
ii) For each name - Pick up all the rows from Sheet1
iii) After inserting all rows for each person - insert a summary ro
which sums up the hours for that person each day.
This action needs to be repeated for each employee in the Sheet2.
Hope i have explained everything clearly.
Any helps---really appreciated.
Thanks in advance
Dipt
I have an XL sheet with 3 sheets
1) Sheet1 - contains a dump of data from database containing the tim
report of each employee in the organisation. This data is dumped on
weely basis. The demographics of the data is such that an employee ca
be working on more than one project and will be charging his time spen
to more than one project. Thus, each employee may have more than on
row of data for a particular week.
2)Sheet 2 has a list of employees I am intertested in --- I don't wan
all the employee
3)Sheet 3 - this is the sheet which I need to populate with th
information -- Logic required here is
i) Lookup all the names from Sheet 2
ii) For each name - Pick up all the rows from Sheet1
iii) After inserting all rows for each person - insert a summary ro
which sums up the hours for that person each day.
This action needs to be repeated for each employee in the Sheet2.
Hope i have explained everything clearly.
Any helps---really appreciated.
Thanks in advance
Dipt