copy of worksheet

  • Thread starter Thread starter TechnoGram
  • Start date Start date
T

TechnoGram

I have a woorkbook with a master worksheet which include formulas. I
want to copy the master into individual sheets but maintain the
various formulas. How can I do this
 
To copy a worksheet, right click on the tab with worksheet name. Select 'Move
or copy' and follow the directions in the dialog box. (You will need to check
the box for 'Create a copy' otherwise it will only move the worksheet.)

In the dailog box, Click the dropdown arrow to select same workbook, another
open workbook or a new workbook.

Regards,

OssieMac
 
To copy a worksheet, right click on the tab with worksheet name. Select 'Move
or copy' and follow the directions in the dialog box. (You will need to check
the box for 'Create a copy' otherwise it will only move the worksheet.)

In the dailog box, Click the dropdown arrow to select same workbook, another
open workbook or a new workbook.

Regards,

OssieMac





- Show quoted text -
Click to expand...

I will give it a try. I was selecting the sheet and copy pasting it.
Is this why my formulas did not work?
 
Another way is to CTRL-drag the worksheet tab. Hold down the CTRL key
and drag the tab along the bottom of the sheet using the mouse.
Release the mouse button, then the CTRL key. This will give you an
exact copy of the sheet.

Hope this helps.

Pete
 
Another way is to CTRL-drag the worksheet tab. Hold down the CTRL key
and drag the tab along the bottom of the sheet using the mouse.
Release the mouse button, then the CTRL key. This will give you an
exact copy of the sheet.

Hope this helps.

Pete





- Show quoted text -
Click to expand...

Having a bit of a struggle with this...
When I am in the VB Editor I copy and pasted the example given for
both the registry and text ways of doing it. When I go to run the
macro on the text method it gives me an error message:
compille error. ambiguous name detected: NextSeqNumber

When I go back to my workbook and either drag and drop or copy the
worksheet there is nothing.
I tried saving the sheet as a template and then opening it but stilll
nothing and besides this would not end up with the result of the
invoices being in one workbook. Not too sure if having the master
copy of the invoice in it's own workbook is not a better idea.....
Then I could call the template workbook master invoice and the
workbook with the individual invoices called simply invoices.
Help???
 
I think that ambiguous name detected is more than one procedure with the same
name.

If you need more help, if you post the code you are using then it might make
it easier to understand exactly what you are trying to do.
 
Back
Top