Copy worksheet from one book to open workbook

  • Thread starter Thread starter Nev
  • Start date Start date
N

Nev

Hi there

I hope you can help. I want to copy a worksheet from one book to the
workbook that is already open.
Example - open closed book called Owner Rep and copy the single sheet in
that book called sheet1 to the open book and replace existing sheet1.

thanks

Nev
 
xl2003
right click sheet tab>move or copy>create a copy>select a book
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Excel Protection 2
Copy a worksheet 1
Excel 2007 Copy Worksheet Problem 2
Copy/Paste 1
copy values from 11 books to 1 sheet 7
copy new worksheet 2
copy ranges 4

Back
Top