Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving a sheet from one Excel file to another?
I have two Excel files containing several sheets each. How do I move a sheet
from one file (workbook) to another? I tried the move or copy function in the file I want to move the sheet from, however, the file I want to move the sheet to does not appear in the "To book" drop down list. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving a sheet from one Excel file to another?
You need to open both files.
-- Greetings from New Zealand Bill K "Kathy" wrote in message ... I have two Excel files containing several sheets each. How do I move a sheet from one file (workbook) to another? I tried the move or copy function in the file I want to move the sheet from, however, the file I want to move the sheet to does not appear in the "To book" drop down list. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving a sheet from one Excel file to another?
Both files are open.
"Bill Kuunders" wrote: You need to open both files. -- Greetings from New Zealand Bill K "Kathy" wrote in message ... I have two Excel files containing several sheets each. How do I move a sheet from one file (workbook) to another? I tried the move or copy function in the file I want to move the sheet from, however, the file I want to move the sheet to does not appear in the "To book" drop down list. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving a sheet from one Excel file to another?
That worked. Both files have to be opened together, instead of separately
through Excel. Thanks. "Bill Kuunders" wrote: You need to open both files. -- Greetings from New Zealand Bill K "Kathy" wrote in message ... I have two Excel files containing several sheets each. How do I move a sheet from one file (workbook) to another? I tried the move or copy function in the file I want to move the sheet from, however, the file I want to move the sheet to does not appear in the "To book" drop down list. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving a sheet from one Excel file to another?
I've tried to get the same symptom by protecting workbooks etc............no
luck. Other way to move a sheet is after arranging the windows. <window< arrange< tiled. hold control and drag a tab across. -- Greetings from New Zealand Bill K "Kathy" wrote in message ... Both files are open. "Bill Kuunders" wrote: You need to open both files. -- Greetings from New Zealand Bill K "Kathy" wrote in message ... I have two Excel files containing several sheets each. How do I move a sheet from one file (workbook) to another? I tried the move or copy function in the file I want to move the sheet from, however, the file I want to move the sheet to does not appear in the "To book" drop down list. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving a sheet from one Excel file to another?
hi kathy ,when u open u r work sheet , select the work sheet whould like to
move & use shortcut Key " Alt + E + M " after pressing this short cut key u will find a dilog box , in that dilog box u can select the the place where u would like to move u r work sheet & than press ok, "Kathy" wrote: I have two Excel files containing several sheets each. How do I move a sheet from one file (workbook) to another? I tried the move or copy function in the file I want to move the sheet from, however, the file I want to move the sheet to does not appear in the "To book" drop down list. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving a sheet from one Excel file to another?
dont forgot u have to open both the files .......
"Kathy" wrote: I have two Excel files containing several sheets each. How do I move a sheet from one file (workbook) to another? I tried the move or copy function in the file I want to move the sheet from, however, the file I want to move the sheet to does not appear in the "To book" drop down list. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reflecting info between an excel file and a word one or two excel file. | Excel Discussion (Misc queries) | |||
auto file path update when excel sheet moved to another directory. | Excel Discussion (Misc queries) | |||
Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) |