PDA

View Full Version : Sleeper: Macro to stack lists until empty



wiro
06-12-2018, 12:41 AM
Hi :)

I have two lists that are generated from user input. They vary in length and can be a maximum of 1000 rows each.



The first list adds a + in front of every word.
The second list adds brackets [] around each phrase.


I'd like to use a macro to stack the lists until they're empty.

Column B has the first list. There are SUBSTITUTE formulas in every cell down to row 1001. Same goes for column D, which holds the second list.

Assume that I put in values and generate two lists of 20 rows each. I want the macro (activated by a button) to stack the both lists and create a 40 row list.

I've tried a couple of online solutions but to no avail.

EDIT: Uploaded a file for reference.

SamT
06-12-2018, 02:09 AM
Use Go Advanced and below the post Editor, the Manage Attachments to upload a sample workbook with a "Result" sheet showing what the final result of the macro should look like.

Include about 10 items in all lists and about 10 formulas in that column on the "original" sheet