I'm fairly new to VBA so I am wondering if someone can help. I have
a .txt file that I have imported into excel and I have been able to
delete all of the unwanted areas. I'm trying to find a way to cut and
paste this data into another workbook. However, the workbook is a
template so I have to fit the right data into the right position or
then when reading the data it will make no sense. Right now, I have
gotten to a point where I can copy then paste special, transpose, then
delete so it acts as a cut and paste. But I can't figure out how to
take that data and put it into a new workbook. Also, is there a way to
do a fixed width and use comma separators? Because when I try it does
nothing.