Man I must be STUPID!
I figured it out! When I made my sheets, 52 in all, I coppied from
page 1! So the name was not sheet 2 it was sheet1(2). When I figured
this out and changed the sheet names to Week 1 through Week 52, it
worked like a charm!
Great forum Thanks!
--
firecord
------------------------------------------------------------------------
firecord's Profile:
http://www.excelforum.com/member.php...o&userid=24490
View this thread:
http://www.excelforum.com/showthread...hreadid=380884