Results 1 to 7 of 7

Copy multiple columns in multiple workbooks into a seperate worksheet (problem with code)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    Copy multiple columns in multiple workbooks into a seperate worksheet (problem with code)

    The following code won't let me copy from the first workbook. I get a run time 1004 error stating "That command cannot be used on multiple selections".

    I would rather not have to copy this by column for each of the 4 workbooks so any help getting this in just 4 copy/pastes would be greatly appreciated.

    Sub Stats()
    '
    ' Stats Macro
    ' Copies Raw Data from Teamspreadsheets to MI spreadsheet to calculate stats
    '
    
    Application.ScreenUpdating = False
    
    Workbooks.Open Filename:= _
            "R:\Derivatives - Project Rosetta\BAU-GoLive\Redress Team Folder - DO NOT MOVE\Tracker\New CET Redress Team Trackers\Redress Tracker Team 1.xlsx"
        Sheets("Redress Tracker").Select
        Range("A4:C2000,I4:I2000,J4:J2000,K4:K2000,R4:R2000,S4:S2000,AD4:AD2000,AU4:AU2000,AW4:AW2000,BE4:BE2000,BF4,BF2000").Select
        Selection.Copy
        Sheets("Raw Data").Range("Redress Tracker MI.xlsx").Activate
        Range("A3").Select
        ActiveSheet.Paste
        
    Application.ScreenUpdating = True
    
    MsgBox (Complete!)
    
    End Sub
    Last edited by Sc0tt1e; 02-27-2014 at 11:33 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy & Pasting Multiple Cells and Ranges From Each Worksheet To a Seperate Sheet
    By tuc28869 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2013, 02:57 PM
  2. [SOLVED] VBA code to copy cell range from all worksheets for multiple workbooks
    By Beany213 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-21-2013, 12:34 PM
  3. Copy worksheet to multiple workbooks in a folder
    By MysticGenius in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2012, 07:10 AM
  4. code help - consolidating multiple workbooks into one worksheet
    By Schretter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2010, 06:41 PM
  5. Copy specific columns from mult workbooks to seperate workbook
    By excelgrrl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2009, 10:12 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1