Hello,
So there are two parts to this post as I would like to learn along the way.
1. I have the input and it is 10 columns of data but I would like a macro that copies all data to column A.
Column A stays in A, Col B moves to the bottom of Col A data, Col C moves to the bottom of Col A data.
I have included 'Output' worksheet as an example of the output.
I would also like this macro to work on a variable amount of columns. So it will work if there are 4 columns or 11 columns.
2. Now, I would like to take the Output and add a prefix and a suffix to the single column of data created in part 1.
3. If anyone really wants to show off they can copy the final single column to txt then save the txt with the extension '.dxf'.
Not sure how to end these forums since it is my first so thank you in advance.
Bookmarks