 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Copy worksheet into several worksheets in the same or another work
Need help with copying a worksheet into several worksheets in the same or another workbook I have found the Merge Works formula, but, as I understand it, that is different from what I am trying to accomplish. That appears to be for what they call shared workbooks. Well, this would not be that. These workbooks would be independent workbooks. Lawrence S. Miller Lawrence, I think I understand what you mean. If you right click on the sheet you want to copy, then choose 'move or copy' You can to move or copy (tick / check the box for 'create a copy') then choose which of your open workbooks you want to move or copy it to in the top field, or choose 'new book' and in the second field you can decide where the sheet goes in the book. Barbara > Need help with copying a worksheet into several worksheets in the same or > another workbook [quoted text clipped - 3 lines] > would be independent workbooks. > Lawrence S. Miller Hi Barbara and thanks so much for trying to help. I found my answers at http://www.rondebruin.nl/tips.htm. I hope you will help me again in the future when I am at a loss. Since I am such a tyro or neophyte with Excel, I am bound to need more assistance shortly. Regards and all the best, Barbara Wiseman, Lawrence > Lawrence, > I think I understand what you mean. [quoted text clipped - 15 lines] > > would be independent workbooks. > > Lawrence S. Miller See Ron de Bruin's site for code assistance. http://www.rondebruin.nl/tips.htm Browse through the section on Copy/Paste/Merge examples Gord Dibben MS Excel MVP >Need help with copying a worksheet into several worksheets in the same or >another workbook [quoted text clipped - 3 lines] >would be independent workbooks. >Lawrence S. Miller Thanks Gord. I see you gave me a treasure trove of helps at Ron de Bruin's site. I haven't looked thoroughly yet but I am sure you are right and I will find what I need there. Thanks again. Lawrence > See Ron de Bruin's site for code assistance. > [quoted text clipped - 11 lines] > >would be independent workbooks. > >Lawrence S. Miller |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.