Hi there,

Right click on tab name (Sheet1)

Select "Move or Copy", select the location where you want the sheet to
go. Tick the "Make a copy" button at the bottom and click OK

Everything should stay the same.

Thanks
Gazzr


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=539174