Results 1 to 2 of 2

Transferring Columns using Preset Headers

Threaded View

undergraduate Transferring Columns using... 01-07-2011, 11:56 AM
Marcol Re: Transferring Columns... 01-07-2011, 12:36 PM
  1. #1
    Forum Contributor
    Join Date
    01-28-2010
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    105

    Transferring Columns using Preset Headers

    The following spreadsheet, has columns in J through W.
    I have a list of the column headers that I want in Columns B through H.
    I would like to transfer relevant columns in J through W into respective columns in B through I.

    The problem is that the order of columns may differ in J through W and some columns may be omitted in different Spreadsheets. However, the columns in B through I remain constant

    You can see what I mean by looking at the attached spreadsheet on how it looks before and how I want it look after in the sample spreadsheet.

    I believe this requires a Macros. Thank you well in advance for your help.
    Attached Files Attached Files

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