|
Copying
Hi
How can i copy a page from worksheet to another worksheet in the same workbook without using copy and paste? |
Copying
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: Hi How can i copy a page from worksheet to another worksheet in the same workbook without using copy and paste? |
Copying
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 "Stefi" wrote: 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: Hi How can i copy a page from worksheet to another worksheet in the same workbook without using copy and paste? |
Copying
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? -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
Copying
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" wrote: 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? -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
Copying
Tue, 8 Jan 2008 02:22:01 -0800 from hassan el touby
: "Stan Brown" wrote: 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? 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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
Copying
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 On Tue, 8 Jan 2008 02:22:01 -0800, hassan el touby wrote: 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" wrote: 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? -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
| All times are GMT +1. The time now is 12:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com