| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying Excel Cells including Names Into Existing Spreadsheet
I am having difficulty coping a worksheet from one workbook to another. The
second workbook being a revision of the first. The revision work was VBA and not to the sheet itself. I have somehow lost the cell names on the new revision and need them in order to run the VBA code. Is it possible to paste the old sheet onto the new one keeping the cell names? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying Excel Cells including Names Into Existing Spreadsheet
MonkeyHanger
Why not right click on the worksheet tab you want to copy and from the menu select "copy or move", then follow the questions and move it (or a copy) to the other workbook? This will move named ranges, macros, formating, etc. It moves it all or a true "copy" of your worksheet. Mike Rogers "MonkeyHanger" wrote: I am having difficulty coping a worksheet from one workbook to another. The second workbook being a revision of the first. The revision work was VBA and not to the sheet itself. I have somehow lost the cell names on the new revision and need them in order to run the VBA code. Is it possible to paste the old sheet onto the new one keeping the cell names? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying Excel Cells including Names Into Existing Spreadsheet
I'm sure that you can do this via paste special function
"MonkeyHanger" wrote: I am having difficulty coping a worksheet from one workbook to another. The second workbook being a revision of the first. The revision work was VBA and not to the sheet itself. I have somehow lost the cell names on the new revision and need them in order to run the VBA code. Is it possible to paste the old sheet onto the new one keeping the cell names? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying and using formulas including worksheet names | Excel Discussion (Misc queries) | |||
| download existing spreadsheets into another existing spreadsheet | Excel Discussion (Misc queries) | |||
| copy column and header names from existing spreadsheet to new spre | New Users to Excel | |||
| How do I print an excel spreadsheet including the matrix lines? | New Users to Excel | |||
| Excel Spreadsheet from Access. List of names changes as names are | Excel Discussion (Misc queries) | |||
Hybrid Mode
