Copy worksheet into several worksheets in the same or another work

[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

 

[Barbara Wiseman]

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

 

[Gord Dibben]

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

 

[lawrencae]

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

 

[lawrencae]

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