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

--
Message posted from http://www.ExcelForum.com

is that all you need?

-----Original Message-----
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 time
report of each employee in the organisation. This data is
dumped on a
weely basis. The demographics of the data is such that an
employee can
be working on more than one project and will be charging
his time spent
to more than one project. Thus, each employee may have
more than one
row of data for a particular week.
2)Sheet 2 has a list of employees I am intertested in ---
I don't want
all the employee
3)Sheet 3 - this is the sheet which I need to populate
with the
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 row
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
Dipti


---
Message posted from http://www.ExcelForum.com/

.

How many records are we talking about in Sheet1?

Are they alphabetized by the employees' names? - Pikus

--
Message posted from http://www.ExcelForum.com