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

**arcamp** · 02-11-2013, 08:47 PM

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

**arcamp** · 02-11-2013, 09:04 PM

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.

**JBeaucaire** · 02-11-2013, 09:52 PM

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.

**JBeaucaire** · 02-21-2013, 12:14 PM

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.

**arcamp** · 02-21-2013, 04:21 PM

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

**arcamp** · 02-21-2013, 05:18 PM

Finished Product

Please Login or Register  to view this content.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions