+ Reply to Thread
Results 1 to 2 of 2

Group all selected columns except for the columns with a specific name

  1. #1
    Registered User
    Join Date
    10-23-2019
    Location
    US
    MS-Off Ver
    10
    Posts
    1

    Group all selected columns except for the columns with a specific name

    Hi all, I am new here and I am also new to learning VBA. I am looking for help to create a macro that groups all columns in a selected range except for the columns with a specific name in row 12.
    FACTS:
    The table is huge, and I only need to see the columns in the table called “Cumulative Ending Balances”. This task is completed often an it takes a long time to group all the columns that are not needed manually.
    - I have a table on range E12: DLO64, the table headers are on row 12
    - I want to group all the columns in the range that I select (E12: DLO64), except for the columns which name of header (row 12) is “Cumulative Ending Balances”

    Can some one please help?

  2. #2
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    1,004

    Re: Group all selected columns except for the columns with a specific name

    Hi, di_mexi
    Welcome to the FORUM.
    You may try this code:

    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)

Similar Threads

  1. VBA - Selecting all cells in specific columns from selected rows
    By mrichardson.music in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-26-2018, 07:59 AM
  2. Auto populate worksheet on selected columns with specific role
    By mitsumi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2018, 12:50 PM
  3. Group together rows using specific data from 2 different columns
    By DSET13 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-28-2015, 06:51 PM
  4. [SOLVED] Decreasing selected specific range by 14 columns from the left
    By drrazor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2014, 11:00 AM
  5. [SOLVED] Need a Macro to group certain columns and save them as a separate file in specific folder
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-31-2013, 11:51 AM
  6. [SOLVED] Macro to group columns based on specific criteria in entire workbook
    By kbkumar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-09-2012, 04:47 AM
  7. Sorting a specific group of columns by a member of that Column
    By 00Able in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2011, 09:22 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