you're welcome and thanks for the feedback

"Xeraco" wrote in message
...
Thanks Julie....Worked A Treat.

"Xeraco" wrote:

I have a an eight week cycle working shift pattern. What I want to do is
be
able to have a mock template of the days of the week and when I enter the
week no of the eight week cycle, it returns the shifts for that
week....hope
that makes sense...

Any help or ideas welcome

Thanks