+ Reply to Thread
Results 1 to 2 of 2

Consolidate set of multiple columns to one set of columns to a new sheet

  1. #1
    Registered User
    Join Date
    05-15-2013
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    39

    Post Consolidate set of multiple columns to one set of columns to a new sheet

    Hi All,
    Appreciate all your help in getting below assistance.

    I have a sheet with data in some columns however I want to copy data from only specific columns and paste to a new sheet using VBA

    For instance, I want to copy data from columns F:G(5 columns) from my datasheet to a new sheet in A:E(5 columns) and go back to my datasheet and copy data from M:Q(5 columns) and move to newly created sheet and paste data in column A:E(5 columns) and not in first row but in first blank row after my first set of data from datasheet and again go back to my datasheet and copy T:X(5 columns) and move to newly created sheet and paste data in column A:E(5 columns) and not in first row but in first blank row after my second set of data from datasheet.
    So in short I have a set of 5 columns data 3 times in my data sheet and I am trying to move all data into one set in a new sheet one after other.
    And number of rows in set might differ too.

    I did see some similar question and solutions however they were trying to copy and paste only one column and my problem is not one column but set of 5 columns....I tried to tweek the provided solutions but no luck.

    Time in assisting is much appreciated please..

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,069

    Re: Consolidate set of multiple columns to one set of columns to a new sheet

    How about
    Please Login or Register  to view this content.
    You'll need to change the first range As you said it's 5 columns but only showed 2

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Consolidate columns from multiple worksheets.
    By PaulAllen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2017, 12:13 AM
  2. [SOLVED] Consolidate Multiple Columns into Single Column
    By AllanTheCowboy in forum Excel General
    Replies: 17
    Last Post: 08-02-2015, 06:30 PM
  3. Formula to consolidate hours (multiple columns of criteria)
    By egordon in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-13-2015, 04:30 PM
  4. Consolidate Data In Multiple Rows and Columns Into One Row
    By KiwDaWabbit in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-09-2015, 03:06 PM
  5. Consolidate multiple columns and rows into one Column
    By jewels3059 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2013, 11:12 AM
  6. Replies: 3
    Last Post: 03-12-2013, 02:34 PM
  7. [SOLVED] Refining Macro to Consolidate Columns into one Sheet
    By lonewolfe2015 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-26-2012, 08:08 PM

Tags for this Thread

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