+ Reply to Thread
Results 1 to 6 of 6

Generate a SKU based on columns of data

  1. #1
    Registered User
    Join Date
    02-13-2017
    Location
    Lynchburg, VA
    MS-Off Ver
    2013
    Posts
    3

    Generate a SKU based on columns of data

    Hi Experts!

    I am trying to generate a listing of SKU's (probably thousands) based on an excel spreadsheet with a series of data in columns.



    Capture.JPG


    I would like to auto generate SKU's similar to the following:

    SKU

    TANKRDT00000M100
    TANKRDT00000M1SM
    TANKRDT00000M1MD
    TANKRDT00000M1LG
    TANKRDT00000M1XL
    TANKRDT00000W100
    :
    :
    :
    TANKVLT0VLT0C1XL

    Notice that I start at column 1 item 0, column 2 item 0,column 3 item 0, column 4 item 0, column 5 item 0, column 6 item 0, column 7 item 0
    and then inclement column 7 to item 1 and the next SKU is column 7 item 2...until the last item in column 7 then I reset column 7 back to item 0
    and inclrement column 6 to item 1...and so on until i go through every permutation.

    Please can anyone help with the formul
    Attached Files Attached Files
    Last edited by dgriffis; 02-13-2017 at 09:23 PM. Reason: Adding Attachment

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Generate a SKU based on columns of data

    Hello dgriffis.

    Welcome to the Forum!

    It would be easier to provide a solution if you posted your workbook.

    To Attach a File:

    1. Scroll down to the window below your post Additional Options
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.

    Make sure there is enough data to fully demonstrate the process. Include an AFTER sheet in the workbook to show how you want the results formatted.

    Remember to redact or change any personal, confidential, or sensitive information in the workbook before you post.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    02-13-2017
    Location
    Lynchburg, VA
    MS-Off Ver
    2013
    Posts
    3

    Re: Generate a SKU based on columns of data

    Thank you!
    Apologies for not doing that at first.

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,877

    Re: Generate a SKU based on columns of data

    I think this puts you in the right direction.
    Attached Files Attached Files
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  5. #5
    Registered User
    Join Date
    02-13-2017
    Location
    Lynchburg, VA
    MS-Off Ver
    2013
    Posts
    3

    Re: Generate a SKU based on columns of data

    WOW!!! You are awesome. So how can I tell what the code behind the scenes looks like for this? (yes, I am a dummy)

  6. #6
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,877

    Re: Generate a SKU based on columns of data

    Not me. Thank JBeaucaire for this. I was only smart enough to keep it in my archives.

    When you press ALT-F11 you can view entire code if that's what you mean.

+ 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. Macro to generate or copy a pie chart based in new data of individual columns
    By Oscar Buros in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2014, 10:56 AM
  2. [SOLVED] How to generate a list based on values from several columns
    By KForsman in forum Excel General
    Replies: 8
    Last Post: 06-17-2014, 12:10 PM
  3. I would like to generate data based from a part list. This data is cycle time, and load
    By janusik4341 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2014, 06:27 AM
  4. Replies: 1
    Last Post: 02-25-2014, 10:54 AM
  5. Generate Columns function of data (VBA / BDH function)
    By bryan444 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-28-2012, 03:24 PM
  6. How to have Excel generate values based on my data
    By Jmenace in forum Excel General
    Replies: 1
    Last Post: 07-07-2011, 11:10 PM
  7. How to generate data based on two fields?
    By Aelestra07 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-05-2007, 06:35 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