How to make List created refer by another worksheet data?

  • Thread starter Thread starter Agung Widodo
  • Start date Start date
A

Agung Widodo

Hi All.

My table to check manpower overtime result base on daily working overtime.
Header in 1st row :
(A1)Index No. (B1)Name (AL1)Overtime Total

(Hundreds of employee name...)
Overtime total daily changes base on daily updated data on Column (C:AK)


In second worksheet i make daily updated summary employee that overtime
taken over than 80 hours only

(A5)Index No. (B5)Name (C5)Overtime <80

(Display employee which overtime more than 80 Hours only)


How to make 2nd page updated automatically everyday??
 
Excel provides for an On Open macro... The macro with the name auto_open
are start each time the spread sheet is opened. If auto_open
encompases steps to step through first work sheet to check the time of
each employee and enter overtime result on second worksheet, you should
achieve your objective.

I trust that you can generate the appropriate code, otherwise responds
and I or others will help you.

WindsurferLA
 
Back
Top