+ Reply to Thread
Results 1 to 11 of 11

We are in need of assistance for auto incrementing an Excel document with apparel sizes.

  1. #1
    Registered User
    Join Date
    03-16-2021
    Location
    Bloomington, IL.
    MS-Off Ver
    Office 365
    Posts
    6

    We are in need of assistance for auto incrementing an Excel document with apparel sizes.

    We are in need of assistance for auto incrementing an Excel document with apparel sizes.

    For example:

    Small
    Medium
    Large

    Screenshot of Excel document (attached)2021-03-16 14_47_09-Jerrod Davenport _ Microsoft Teams.png

    We would prefer a Macro or VB script.

    Please let us know if anyone has ideas.

    Have a nice day,

    Andrew

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: We are in need of assistance for auto incrementing an Excel document with apparel size

    Hi Andrew and welcome to the forum,

    I think you are looking a Fill Down or perhaps Flash Fill. Watch this YouTube.
    https://www.youtube.com/watch?v=1KimYFzET1w
    If that doesn't do what you want then keep asking.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,102

    Re: We are in need of assistance for auto incrementing an Excel document with apparel size

    Is W always the last letter before the size designation? Is that W the only w in the product-sku? Please provide a sample file as per the yellow banner above.

  4. #4
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,340

    Re: We are in need of assistance for auto incrementing an Excel document with apparel size

    Maybe this will work (as per the others - having the sheet would allow testing and refining)

    entered in D5 and fill down


    Please Login or Register  to view this content.
    edit :
    woops I see you want VBA.
    Anyway this formula is an option.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  5. #5
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,102

    Re: We are in need of assistance for auto incrementing an Excel document with apparel size

    Here is a VBA option, but untested on your data

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    03-16-2021
    Location
    Bloomington, IL.
    MS-Off Ver
    Office 365
    Posts
    6

    Re: We are in need of assistance for auto incrementing an Excel document with apparel size

    MarvinP,

    Thanks for the information.

    Unfortunately, this method didn't help us.

    Have a nice day,

    Andrew

  7. #7
    Registered User
    Join Date
    03-16-2021
    Location
    Bloomington, IL.
    MS-Off Ver
    Office 365
    Posts
    6

    Re: We are in need of assistance for auto incrementing an Excel document with apparel size

    All,

    Here is an example file.

    Hope this helps.

    Thanks,

    Andrew
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    03-16-2021
    Location
    Bloomington, IL.
    MS-Off Ver
    Office 365
    Posts
    6

    Re: We are in need of assistance for auto incrementing an Excel document with apparel size

    Maniacb,

    The, "W" actually stands for white. We have a lot of different colors.

    It is part of the sku, but changes per item.

    Thanks,

    Andrew

  9. #9
    Registered User
    Join Date
    03-16-2021
    Location
    Bloomington, IL.
    MS-Off Ver
    Office 365
    Posts
    6

    Re: We are in need of assistance for auto incrementing an Excel document with apparel size

    Scottiex,

    We greatly appreciate your response.

    This week we will attempt to implement and see what happens.

    Have a nice day,

    Andrew

  10. #10
    Registered User
    Join Date
    03-16-2021
    Location
    Bloomington, IL.
    MS-Off Ver
    Office 365
    Posts
    6

    Re: We are in need of assistance for auto incrementing an Excel document with apparel size

    Maniacb,

    Thank you very much for the VBA script.

    This week we take a look and see if it works well for us.

    Have a nice day,

    Andrew

  11. #11
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,102

    Re: We are in need of assistance for auto incrementing an Excel document with apparel size

    Updated code to work with file

    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. Automated Data Generation in Excel - Auto-Incrementing Custom IDs (Mixed alpha-numeric)
    By piechartking in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2015, 01:47 AM
  2. Assistance incrementing SUM formula row numbers when using reference
    By deepakkumarb22 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-30-2014, 04:26 AM
  3. Assistance in auto populating a roster from another excel document.
    By recoil55 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-24-2014, 06:31 PM
  4. Need assistance with Opening and closing Excel-document
    By RinorM in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-28-2014, 02:01 AM
  5. Replies: 4
    Last Post: 01-25-2013, 12:59 PM
  6. Delete auto incrementing column in Excel sheet?
    By dearnemo385 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-10-2012, 01:10 PM
  7. Auto incrementing excel macro
    By OvertheRhein in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2011, 10:19 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