I have a spreadsheet I've been trying to hack together after 5 years of doing nothing in VBA, and working in a job that involves no programming of any kind. It's my supervisor's brainchild after he heard about something I developed elsewhere and I'm sick of working on it, so I'm willing to pay someone who can help me fix up some circular reference issues and clean/finish off the setup - mostly formulas but some VBA - and debug it. It's Excel 2003 to run on an XP environment, AnalysisToolpak installed. I have the basics up and running, so it shouldn't take a long time to wrap up, and I'd love to have a fast turnaround (2 days) because he's hoping to start using it on Monday. In a nutshell, the sheet is designed to create a task sheet for each shift. There are 3 sections - the header pulls in any events etc and displays them against the (entered) date. The second is for priority tasks that are supposed to happen on 'theDate' (the entered variable in D3) and should always put P1 tasks at the top, but after that needs to group tasks by sector. I've got that basically working with a custom function from ozgrid, but it doesn't have a break subroutine that stops it cycling back to the first matching entry and repeating endlessly. The third section is similar to the top, but for lower priority (proactive) tasks. Also to be grouped by sector, but this bit doesn't have the priority column. The final step is that it has to export the resulting tasking sheet (values only) to a new workbook so that can be archived, and the staff don't have access to muck up the master sheet. I set up a macro to do it, but it may need a once-over. The main difficulty is in setting it up so that tasks can be entered either to run "All" (every day), "Weekday" (certain selected days of the week, can be multiple), "Date" (obvious) or "Interval" (say, every 10 days). There's also a start and end date field that needs to be factored in. I have formulas that basically work for All, Weekday & Date but not Interval yet, but some cells are now registering as circular in that two different fields will lookup the values in the 'selected days of the week' field to check if weekday(theDate) matches, and the key date cell will run formulas based on what frequency is entered, which crosses over with some other formulas. Please PM me your quote or any other questions you need. I'm heading out shortly but will check back in 3 hrs for PMs. Thanks.