Copying

[hassan el touby]

Hi
How can i copy a page from worksheet to another worksheet in the same
workbook without using copy and paste?

 

[Stefi]

Right click on the sheet name tag (at the bottom of XL window), choose Copy
or Move from the local menu, check Copy check box on the dialog window!

Regards,
Stefi


„hassan el touby†ezt írta:

 

[hassan el touby]

no this not what i meant i mean if i have several pages with page breaks how
can i copy a page from them to another worksheet.
thanks

 

[Stan Brown]

Tue, 8 Jan 2008 00:13:01 -0800 from hassan el touby

How can i copy a page from worksheet to another worksheet in the same
workbook without using copy and paste?

When is a door not a door?

Seriously, "copy without copying" is a logical impossibility. Can you
be more explicit about what you're trying to do?

 

[hassan el touby]

i mean if there is any direct command without programing to copy a page
within an excell worksheet to copy this page to another worksheet.
thanks

 

[Stan Brown]

Tue, 8 Jan 2008 02:22:01 -0800 from hassan el touby

i mean if there is any direct command without programing to copy a page
within an excell worksheet to copy this page to another worksheet.

I am pretty sure the answer is No. A "page" is not a real entity like
a worksheet in Excel. Indeed, before you Print or Print Preview it's
not even possible to identify a "page" as an entity.

 

[Gord Dibben]

A "page" on a worksheet would be a range of cells.

You cannot transfer these to another sheet without copying and pasting or using
VBA programming.

You could use "linking" formulas on the target sheet to refer back to the cells
on the source sheet.

Kinda the same as copy/paste without copy/paste.


Gord Dibben MS Excel MVP