Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Excel Sheet to another sheet and preserve formatting?
How do you copy an Excel sheet to another sheet - or create a new worksheet
and use the same formatting as another sheet? Like sheet 1 columns A-M are ..5 width. How can I copy the contents of sheet1 to Sheet2 and preserve the formatting in sheet1? Thanks, Rich |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Excel Sheet to another sheet and preserve formatting?
In VBA
Range("A1:Z600").Copy Workbooks(wbk2).Activate Sheets("Sheet1").Range("A1").PasteSpecial xlPasteFormats Sheets("Sheet1").Range("A1").PasteSpecial xlPasteFormulas (or xlPasteValues) -- Best wishes, Jim "Rich" wrote: How do you copy an Excel sheet to another sheet - or create a new worksheet and use the same formatting as another sheet? Like sheet 1 columns A-M are .5 width. How can I copy the contents of sheet1 to Sheet2 and preserve the formatting in sheet1? Thanks, Rich |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Excel Sheet to another sheet and preserve formatting?
Thanks. I can handle doing it in VBA. My issue was that if I wanted to
retain column widths, row widths, ... With the gui PasteSpecial I can select ColumnWidths, and it will copy the column widths but not the data. And I did not see anything in the gui for copying row widts. I guess I should really as -- how to copy an Excel Sheet to a new Excel Sheet (or to another workbook) and keep everything intact. I know there is a way to do this through the gui - I just can't remember how to do it. "Jim Jackson" wrote: In VBA Range("A1:Z600").Copy Workbooks(wbk2).Activate Sheets("Sheet1").Range("A1").PasteSpecial xlPasteFormats Sheets("Sheet1").Range("A1").PasteSpecial xlPasteFormulas (or xlPasteValues) -- Best wishes, Jim "Rich" wrote: How do you copy an Excel sheet to another sheet - or create a new worksheet and use the same formatting as another sheet? Like sheet 1 columns A-M are .5 width. How can I copy the contents of sheet1 to Sheet2 and preserve the formatting in sheet1? Thanks, Rich |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Excel Sheet to another sheet and preserve formatting?
Rich
Right-click on sheet tab and "Move or Copy" Click "create a copy" and select where you want it to go. Note: you can copy row heights if you select the entire rows, not just the cells in those rows. Gord Dibben MS Excel MVP On Thu, 3 May 2007 15:21:01 -0700, Rich wrote: Thanks. I can handle doing it in VBA. My issue was that if I wanted to retain column widths, row widths, ... With the gui PasteSpecial I can select ColumnWidths, and it will copy the column widths but not the data. And I did not see anything in the gui for copying row widts. I guess I should really as -- how to copy an Excel Sheet to a new Excel Sheet (or to another workbook) and keep everything intact. I know there is a way to do this through the gui - I just can't remember how to do it. "Jim Jackson" wrote: In VBA Range("A1:Z600").Copy Workbooks(wbk2).Activate Sheets("Sheet1").Range("A1").PasteSpecial xlPasteFormats Sheets("Sheet1").Range("A1").PasteSpecial xlPasteFormulas (or xlPasteValues) -- Best wishes, Jim "Rich" wrote: How do you copy an Excel sheet to another sheet - or create a new worksheet and use the same formatting as another sheet? Like sheet 1 columns A-M are .5 width. How can I copy the contents of sheet1 to Sheet2 and preserve the formatting in sheet1? Thanks, Rich |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Excel Sheet to another sheet and preserve formatting?
Thank you for this information.
"Gord Dibben" wrote: Rich Right-click on sheet tab and "Move or Copy" Click "create a copy" and select where you want it to go. Note: you can copy row heights if you select the entire rows, not just the cells in those rows. Gord Dibben MS Excel MVP On Thu, 3 May 2007 15:21:01 -0700, Rich wrote: Thanks. I can handle doing it in VBA. My issue was that if I wanted to retain column widths, row widths, ... With the gui PasteSpecial I can select ColumnWidths, and it will copy the column widths but not the data. And I did not see anything in the gui for copying row widts. I guess I should really as -- how to copy an Excel Sheet to a new Excel Sheet (or to another workbook) and keep everything intact. I know there is a way to do this through the gui - I just can't remember how to do it. "Jim Jackson" wrote: In VBA Range("A1:Z600").Copy Workbooks(wbk2).Activate Sheets("Sheet1").Range("A1").PasteSpecial xlPasteFormats Sheets("Sheet1").Range("A1").PasteSpecial xlPasteFormulas (or xlPasteValues) -- Best wishes, Jim "Rich" wrote: How do you copy an Excel sheet to another sheet - or create a new worksheet and use the same formatting as another sheet? Like sheet 1 columns A-M are .5 width. How can I copy the contents of sheet1 to Sheet2 and preserve the formatting in sheet1? Thanks, Rich |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In EXCEL copy sheet layout to another sheet | Excel Discussion (Misc queries) | |||
How do I copy a print format from sheet to sheet in excel ? | Excel Discussion (Misc queries) | |||
How do I copy formatting from 1 sheet to next in same workbook? | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Preserve original workbook, but add new sheet? | Excel Programming |