Worksheet copy to another workbook

  • Thread starter Thread starter joecrabtree
  • Start date Start date
J

joecrabtree

To all,

I have a workbook called GETDATA.xls. I want to be able to copy all
the worksheets in this workbook apart from one called ' START' to
workbook ANALYSIS.xls.

Please could someone help me with this?

Thanks

Joe Crabtree
 
put this in your ThisWorkbook module.
Sub moveSheets()
For i = 1 To Sheets.Count
If Sheets(i).Name <> "start" Then

Sheets(i).Move Before:=Workbooks("analysis.xls").Sheets(1)
End If
Next
End Sub
 

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 Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Protection 2
Copying multiple worksheets to another workbook 11
Scattered array cells copy to scattered array cells another workbook 14
Excel Move or Copy Stopped Working? 0
How to reference a cell from anther workbook without opening it 0
Copy Worksheet 3
Copy embedded chart with updated data request 2

Back
Top