+ Reply to Thread
Results 1 to 3 of 3

How to insert data in a specific sequence from one column into another column

  1. #1
    Registered User
    Join Date
    02-10-2016
    Location
    Pretoria, South Africa
    MS-Off Ver
    2010
    Posts
    2

    How to insert data in a specific sequence from one column into another column

    Hi,
    I have a column that contains feature codes and a column that lists the parts in the feature. I need to merge it into one column in a different workbook that lists the feature code, then below it all the parts in the feature. For all the features in a filtered list as per the attached screenshot. Screenshot 1.jpg. Can anyone assist? I need to do the same with the descriptions, but if I get the part numbers correct I can use a simple lookup for that. Please help!

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: How to insert data in a specific sequence from one column into another column

    No screenshot attached.

    You're better off posting spreadsheets, post a screenshot and anyone who's willing to solve the problem for you has to retype the data in.Post a spreadsheet remove any sensitive data.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    02-10-2016
    Location
    Pretoria, South Africa
    MS-Off Ver
    2010
    Posts
    2

    Re: How to insert data in a specific sequence from one column into another column

    I can't use concatenate because I don't want to combine the values.
    A simple example of what I want to do:
    Feature Codes Part Numbers
    Code 1 Part 1
    Part 2
    Part 3
    Code 2 Part 4
    Code 3 Part 5
    Part 6
    To change to:
    Feature Code / Part Number
    Code 1
    Part 1
    Part 2
    Part 3
    Code 2
    Part 4
    Code 3
    Part 5
    Part 6

    I use the following macro to copy the filtered range with values only into a new sheet in the correct workbook.
    Sub GenericBomGen()
    '
    ' GenericBomGen Macro
    '


    '
    Workbooks.Open Filename:= _
    "Z:\MINING SPECIFICATIONS\Mine Price List Project\Correct BOM Template To Use..xlsx" _
    , UpdateLinks:=0
    Sheets("Sheet1").Select
    Windows("RMAA - Mining Spec List Rev 2.xlsm").Activate
    Range("A5:F515").Select
    Selection.Copy
    Windows("Correct BOM Template To Use..xlsx").Activate
    Range("A2:F512").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
    End Sub

    Now I need a way to combine the columns as per the example.
    I will use lookups for the other columns.

+ 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. Insert Column before each Specific Column Name
    By shahidsamikhan in forum Excel General
    Replies: 5
    Last Post: 12-30-2014, 05:46 PM
  2. [SOLVED] Searching for specific sequence of numbers down a column?
    By 1st in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-15-2014, 05:29 AM
  3. [SOLVED] userform insert data on next empty row in specific column regardless of formulas
    By keiperg813 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2013, 11:46 AM
  4. Insert column and fill column upto where data is in previous column
    By aka189 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-24-2012, 06:07 AM
  5. Replies: 4
    Last Post: 07-24-2012, 11:58 AM
  6. Search in every column for a value in a specific row, then insert a column before if match
    By manueslapera in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2012, 04:48 PM
  7. [SOLVED] [SOLVED] loop to insert sequence in column
    By Greg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2006, 07:55 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