Hi

I could really do with some one help with this if possible???

The problem which I have is I have 52 sheets for the year and a master
sheet for data to be edited. I want the to enter a week number E.g.
(Wk2) into a cell, and the macro would look up that worksheet which
already exsists and copy the worksheet tot hat sheet.

E.g.

If I enter Wk2 into cell (Q7) on the master sheet, I would want the
sheet to copied to Wk2.

Hope some one can help


--
bsnapool
------------------------------------------------------------------------
bsnapool's Profile: http://www.excelforum.com/member.php...o&userid=36115
View this thread: http://www.excelforum.com/showthread...hreadid=558866