I created a form under worksheet 1, how do I copy the same form to worksheet 2
wihtout having to format worksheet 2?

To make an exact copy of an existing sheet, simply right-click on the
sheet tab and select Move or copy.

In the dialogue box that appears be sure to check the option box for
"create a copy."



Apple Pie Queen Wrote:
I created a form under worksheet 1, how do I copy the same form to
worksheet 2
wihtout having to format worksheet 2?


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=527394

"Apple Pie Queen" wrote:

I created a form under worksheet 1, how do I copy the same form to worksheet 2
wihtout having to format worksheet 2?
I tried the right click and checked off create a copy, it came up as Sheet 1
(2) instead on Sheet 2, I just want on Sheet 2.

Delete Sheet2 and rename Sheet1(2) to Sheet2?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Apple Pie Queen" wrote in message
...


"Apple Pie Queen" wrote:

I created a form under worksheet 1, how do I copy the same form to
worksheet 2
wihtout having to format worksheet 2?
I tried the right click and checked off create a copy, it came up as Sheet
1
(2) instead on Sheet 2, I just want on Sheet 2.