Scheduling

[Matt]

Hi
I'm trying to develop a system that will drag out a 16 week roster from a
monthly (annual)schedule.
I have seven worksheets,
One illustrates an commencement of the week that the classes commence.
The second details the week commencing& the days of that week (and is
summarized into months, (eleven months are hidden)
The third and forth sheets are the sixteen week roster for chefs and
management students I have written a macro for this)
The fifth sixth and seventh sheets are for trainer and room allocation
My question is can a macro be written to recognize the date and fill in the
details of subject,session, trainer, and room or is there another method
I am so close...
I can send you the file if you like

 

[joel]

The are two methods of matching dates


1) Convert both dates to a serial date using Datevalue to conver
string dates to a serial date (number).
2) Sse the format function to convertt a serial date (number) to
string

StrDate = format(Mydate,"MM/DD/YY")

Make sure if you are using names of months or date that both string yo
are trying to match have the same letters capitalized.


If you are using the VBA Find method you need to using a string in th
find method even though the workshet cell is a number. The find metho
is matching the text value of the worksheet cell.


set c = cells(what:="4/5/10",lookin:=xlvalues,lookat:=xlwhole)