View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hotherps[_43_] hotherps[_43_] is offline
external usenet poster
 
Posts: 1
Default Change Criteria in Code

Thanks again Tom,

What I am trying to do is to assign functions for people to work in.
I have a column (A) for their name and then I have a row of cell
(D10:AJ10) that lists the time of day on 20 minute intervals beginin
with 12:00am. I want to insert a function for each cell in the row
There are many possible functions.

Lower on the sheet (C400:C425) Each function is listed. Next to eac
function is the number of hours required to perform the function fo
that day broken out by 1 hour intervals. "So if Pick" is the functio
in C400 i need to look at D400 (12:00am) to see how many hours ar
needed. If the number is than zero then assign the task Picks to th
employee in the corresponding row up top.
Then loop through the range of tasks D401, D402 etc. Until all task
are 0 or there are no more employees to assign.

I hope that makes sense to you. I'm going to attch a sample.
Thanks so much for your help on this!

Attachment filename: schedule.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=50797
--
Message posted from http://www.ExcelForum.com