Results 1 to 12 of 12

Macro To Organize Header Columns

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-15-2007
    Location
    Bend, Oregon
    MS-Off Ver
    Office 2016 Windows
    Posts
    161

    Macro To Organize Header Columns

    Hello,
    I would appreciate some help on a Macro that organizes my columns. The excel files I receive all have column headers and contain below A-P, but the headers may not come in the order as below, meaning A may equal IS_Color, F may equal Title. I would like to have the Macro to arrange columns so they match the order as below, column A=Title, B=Fixed Price etc. Also these column headers all have data below them, so can the corresponding data also be moved to keep same data under the correct header. The rows below the columns headers may range, could be 10 rows, may be 30 rows, so if the Macro can read the amount of data and end with the correct number of rows.

    A=Title
    B=Fixed Price
    C=SKU
    D=Cond. Descr.
    E=Description
    F=IS_Brand
    G=IS_Model
    H=IS_Color
    I=IS_Pattern
    J=IS_Original/Reproduction
    K=IS_Object Type
    L=IS_UPC
    M=IS_Main Color
    N=IS_Size
    O=IS_Service
    P=Pictures

    Possible one Excel file I may receive, random columns:
    Capture_Original.JPG

    Below is how I would like columns to arrange, no matter what column sort order I may receive the original file.
    Capture.JPG

    Thank you very much, JR
    Last edited by gaspower; 05-22-2018 at 08:52 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to delete columns based on header
    By sfadam in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-25-2015, 05:15 PM
  2. [SOLVED] Organize multiple columns into organised Labelled columns
    By ivanpersie in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-30-2015, 10:36 AM
  3. organize columns in a better format
    By travelmail26 in forum Excel General
    Replies: 10
    Last Post: 12-05-2014, 01:17 PM
  4. Macro to unlock cells in particular columns based on header value
    By Napa in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-17-2013, 05:20 PM
  5. macro to delete blank columns - includes header row
    By bluesea in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2012, 12:18 PM
  6. Organize Rows and Columns
    By Hady in forum Excel General
    Replies: 1
    Last Post: 08-09-2005, 07:05 AM
  7. Organize and sort columns
    By J in forum Excel General
    Replies: 2
    Last Post: 02-28-2005, 09:06 PM

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