Post back with an example or two of the sheet names. HTH Otto
"honeygirl119" wrote in message
...
I have worksheets named for every week of the year for the division offices
at my work to quickly locate and fill in the proper information. Every
year
the dates of the week change...is there a way I can have those
automatically
update or change by changing one? My friend swears she has done this in
the
past but I can't seem to get it to work.