+ Reply to Thread
Results 1 to 6 of 6

Expand on Parse Function/ Column to Column - Contiguous Data to include quantities

  1. #1
    Registered User
    Join Date
    02-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    4

    Expand on Parse Function/ Column to Column - Contiguous Data to include quantities

    https://sites.google.com/a/madrocket...umn-to-columns

    Long time lurker, first time posting. I love this site as it has helped me out of the mud more than a few times, so thank you all for the help. To get to it:

    I would like you to expand on the macro in the link above and below- Parse Function/ Column to Column /Part 2 - Contiguous Data to include quantities. IT IS ALMOST PERFECT!!!!

    Please Login or Register  to view this content.

    PROBLEM:
    Can the macro include a loop that looks at Column B for a quantity for each name in column A?


    See attached for Example Sheet
    Attached Files Attached Files
    Last edited by JBeaucaire; 12-27-2019 at 10:21 PM.

  2. #2
    Registered User
    Join Date
    02-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Expand on Parse Function/ Column to Column - Contiguous Data to include quantities

    To explain further, these are marking tags that I burn out for items that I build. We tie these to Beams, plates, etc. and use them to track items through our shop.
    At the moment we hand stamp each tag!!!!! it is not efficient and prone to allot of error.
    So I an in need of a template that will create a whole sheet of item#s based on there quantities.
    The ability to tell it how may rows to stack is important as it lets me be able to place this on different size sheets of metal.

  3. #3
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Expand on Parse Function/ Column to Column - Contiguous Data to include quantities

    Use this macro on your original list to make a new list, then run the other macro to reorder it.
    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Expand on Parse Function/ Column to Column - Contiguous Data to include quantities

    thanks for the feedback. If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.

  5. #5
    Registered User
    Join Date
    02-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Expand on Parse Function/ Column to Column - Contiguous Data to include quantities

    thanks JB! I tweaked it a little and worked like a charm!

  6. #6
    Registered User
    Join Date
    02-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Expand on Parse Function/ Column to Column - Contiguous Data to include quantities

    Finished Product

    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)

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