+ Reply to Thread
Results 1 to 4 of 4

Help with moving columns from multiple worksheets into one worksheet side by side

  1. #1
    Registered User
    Join Date
    12-15-2012
    Location
    Africa
    MS-Off Ver
    Excel 2003
    Posts
    3

    Help with moving columns from multiple worksheets into one worksheet side by side

    Have seen a lot of examples for moving data from multiple sheets to one worksheet, but they are adding data to the next empty row. Instead, I am trying to find an example of moving the columns next to each other in the consolidated worksheet.

    Basically, want to move column B from Sheet1 and Sheet2 to columns B and C in Summary.

    Have been trying, but can't get the columns counter to move.

    Please help.
    Attached Files Attached Files

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620
    If you just want to copy column B from Sheet1 and Sheet2 try this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    12-15-2012
    Location
    Africa
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Help with moving columns from multiple worksheets into one worksheet side by side

    Thanks.

    I have over 100+ sheets to copy from, so I need a loop that will paste to the next available column.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: Help with moving columns from multiple worksheets into one worksheet side by side

    You only mentioned Sheet1 and Sheet1.

    Anyway, try this.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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