Sorry I am a begginenr- I have a worksheet that has formulas. When I try to
copy this worksheet into a tab on another worksheet the values are copied but
not the formulas. What am I doing incorrectly?

Formulae do get copied when you copy a worksheet.

Can you describe the steps you perform?

Try this
Right-click on the worksheet tab, choose Move or Copy and make your choices
(Click on create a Copy).

Formulae should also be copied to the new sheet.

"vj1031" wrote:

Sorry I am a begginenr- I have a worksheet that has formulas. When I try to
copy this worksheet into a tab on another worksheet the values are copied but
not the formulas. What am I doing incorrectly?

Do you have each workbook running in a separate instance of Excel?

If so, close one instance and open both workbooks in a single instance.


Gord Dibben MS Excel MVP

On Tue, 28 Oct 2008 10:12:00 -0700, vj1031
wrote:

Sorry I am a begginenr- I have a worksheet that has formulas. When I try to
copy this worksheet into a tab on another worksheet the values are copied but
not the formulas. What am I doing incorrectly?