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/

.