Moving/Copying worksheets with formulars

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

Is there a way, using code, to copy (move) a worksheet to another worksheet
without losing the formulars which are contained in the copied worksheet.
I have a worksheet that I need to copy over to another worksheet, but
because the 1st worksheet contains formulars that are based on other sheets
in the workbook I know I will get and error. So I need to figure out a way to
move the 1st worksheet over with all the data on it intact.
 
first off open both worksheets (the one containing the sheet you want to copy
and the one you want to place it in)

right click on the tab of the sheet you want to copy, select 'move or copy',
then choose the filename of the worksheet where you want it.

i believe this should do it..hth!

michelle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Move or Copy Stopped Working? 0
Putting two formulars together in excel 3
Putting two formulars together in a cell in excell 3
Excel formula help wanted 3
How do I move data from one worksheet to another? 1
Cannot copy worksheet to another file 2
Excel Highlighting duplicates 0

Back
Top