| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge Workbooks
Hi all,
I have workbooks to be merged into one, when I open two workbooks side by side, I copy one worksheet into another workbook. Because, the two workbooks have same definition of Name, so I am asked to choose which Name to use. Since there are many Names in my workbooks, I am prompted many times. Is there any method to erase the prompts and choose Yes as default. Clara -- thank you so much for your help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge Workbooks
Hi,
See online help "Merge workbooks" and "Troubleshoot merging workbooks ' Challa Prabhu "clara" wrote: Hi all, I have workbooks to be merged into one, when I open two workbooks side by side, I copy one worksheet into another workbook. Because, the two workbooks have same definition of Name, so I am asked to choose which Name to use. Since there are many Names in my workbooks, I am prompted many times. Is there any method to erase the prompts and choose Yes as default. Clara -- thank you so much for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merge workbooks | Excel Worksheet Functions | |||
| I want to merge data from 2 different workbooks | Excel Worksheet Functions | |||
| Trying to Merge 2 Workbooks | Excel Discussion (Misc queries) | |||
| merge workbooks | Excel Worksheet Functions | |||
| Merge Workbooks Grayed Out | Excel Worksheet Functions | |||
Linear Mode
