nnick
07-14-2015, 11:34 AM
Good day everyone!
I am having a bit of trouble figure out how to go about coding a macro to do what I want. I hope what I'm trying to do it not too hard.
What I'm trying to do is merge columns B through E into column B with a comma in between everything (I don't want to select which columns but rather provide static columns in the code, with the ability to change them when needed) Then I want to delete the data in columns in C through E.
In addition, I want a way for it to skip empty rows (needed for future use) and for the loop to end when 5 consecutive empty rows occur. (Again for future use, I'd like to have the ability to be able to change the value of 5 to something else.
I have attached an example of what I have and what my goal is. The data is just used as an example. The real document goes up to column J and has roughly 10,000 rows but I'm only interested in columns B through E with every row
13925
Thanks for everyone that can help!
I am having a bit of trouble figure out how to go about coding a macro to do what I want. I hope what I'm trying to do it not too hard.
What I'm trying to do is merge columns B through E into column B with a comma in between everything (I don't want to select which columns but rather provide static columns in the code, with the ability to change them when needed) Then I want to delete the data in columns in C through E.
In addition, I want a way for it to skip empty rows (needed for future use) and for the loop to end when 5 consecutive empty rows occur. (Again for future use, I'd like to have the ability to be able to change the value of 5 to something else.
I have attached an example of what I have and what my goal is. The data is just used as an example. The real document goes up to column J and has roughly 10,000 rows but I'm only interested in columns B through E with every row
13925
Thanks for everyone that can help!