Copy worksheet into several worksheets in the same or another work

  • Thread starter Thread starter lawrencae
  • Start date Start date
L

lawrencae

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
 
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
 
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
 
Back
Top