+ Reply to Thread
Results 1 to 2 of 2

Consoladate Group of columns

  1. #1
    Registered User
    Join Date
    05-12-2015
    Location
    AU
    MS-Off Ver
    2010
    Posts
    50

    Consoladate Group of columns

    Hi Experts,

    I need help on how to create a VBA to Consolidate a group of 3 columns with Row 1 value are identical and blank will remain unchanged.

    For example:
    • copy sheet1 sheet to backup original data
    • merge AREA-1 (QTY/GROSS/NET) & AREA-4 (QTY/GROSS/NET)
    • retain AREA-1 HEADER TITLE AND DELETE AREA-4 COLUMNS


    note: Areas ranging from Area-1 to Area-50, Rows can be up to 1000.

    EXCEL-MERGE.jpg
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,729

    Re: Consoladate Group of columns

    See next code
    Please Login or Register  to view this content.
    Last edited by PCI; 12-21-2018 at 06:27 AM. Reason: Code more flexible: Const added
    - Battle without fear gives no glory - Just try

+ 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. Group in a Pivot table but keep several text data columns as columns..
    By NunesJunior in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-22-2017, 04:45 PM
  2. Replies: 14
    Last Post: 01-12-2017, 01:41 PM
  3. [SOLVED] Group/Un-group Columns through buttons using VBA
    By KamranMustafa in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-11-2016, 04:23 AM
  4. Replies: 1
    Last Post: 02-03-2016, 06:43 PM
  5. Replies: 2
    Last Post: 01-18-2013, 12:45 PM
  6. Sorting groups of columns to a related group of columns
    By fuadramsey in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-15-2007, 07:56 PM
  7. to convert columns to rows having mulit independent group columns
    By Quacy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-22-2006, 06:25 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