Report generation based on value in two cells

[Setal learner]

Dear All,

I have file with 3 sheets
1. TE Deliverables
2. Job Cards
3. Processes

In all the sheets, data is filled against activity VS date Vs employee
the activity lists is in rows whereas the dates are in column and under each date there are 3 staff. so basically same date is repeated in 3 columns for 3 staff and then following date in 4th column.

Similarly, all 3 sheets are in the same type but the no.of rows varies whereas the no.of columns remains the same.

What i want to create is Daily Report for each staff

(the sheet for the report would be - Daily Report)


1. Daily report for each staff based on following selection
- Date to be selected first
- Name of the staff to be selected

a command button to initiate populate report

once the report is populated, it should only fetch the filled cells against the date for that staff for a particular activity and ignore other blank data generation to be shown in the report.

Is this possible?

 

[Logit]

.
To be accurate on a solution, will need to see your workbook. You can post a copy to www.dropbox.com or similar and
post a link to the file in your next post.

 

[Setal learner]

Dear,

I have uploaded the file in the below link through Google Drive

https://drive.google.com/file/d/0B5uYI_vqWYj2NXYzanVVNWdUejBNc3JZY21hTm5NTV8xc0Zz/view?usp=drivesdk