Copy/Pasting certain columns into another workbook as text

[colinrooms]

I need help trying to figure out how to copy and paste certain columns from one row and pasting them into a separate workbook row. It is a total of 24 columns, but they are not necessarily in order. I would also like the data to be pasted as text, if possible. I am very comfortable in Excel, but not the VBA side of Macros. Once I get started, I might need help with rearranging the columns when pasting if that is possible as well. If someone could help get me started I would greatly appreciate it.

 

[Joe4]

Welcome to the Board!

I think the reason why you have not gotten any replies is because your question is a little too generic. It is hard to program VBA code without knowing the specifics.

If you can provide more details, maybe some data samples, it might improve your chances of getting help.
Note that there are tools you can use to post screen images, mentioned in section B here: http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html