View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wins07 Wins07 is offline
external usenet poster
 
Posts: 17
Default HELP !! Macros to autoexecute on open

Hello I have a task list that are scheduled on different days. I need help
for a code which will short list task due for the current date and/or not
completed from previous days.

My data are as follows
A B C D
Job No Employee Date_due Status
2501 John 03/16/07
2505 Trish 03/23/07 OK
2518 Paul 04/03/07

Upon opening the workbook It would be great if Job 2501 and 2518 could be
shortlisted say on sheet2, whereas sheet1 would contain the above list.

Anyone can help

Thank you your usual coorperation