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.
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.