• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

need help for consolidate sheets in to New Workbook

Amit629

New Member
Good Evening All

i have a file in excel 2003 format and they have 8-9 sheet.i want consolidate all sheet in new workbook in 2007 format.

Request you to please help me to get macro for this.

I m trying this

Sub Consolidate()


Application.ScreenUpdating = False



For Each ws In Worksheets
Windows("Money movement report - Renewals.xls").Activate

Sheet1.Range("A1:y65536").Copy
Windows("MM.xlsx").Activate
Sheets("MM").Activate
ActiveSheet.Paste Range("A1").End(xlUp)
Next ws
End Sub
 
Rather than copying each sheet, you can do a Save As and change the file type. That is the much easier way of converting to new file type.
 
Back
Top