Is this possible?
 

I have information in one row, 39 columns, Sheet 1, I want to copy that
info over to Sheet 2, and use 3 rows, 12 columns.
I used EasyFilter to filter my data.
Can & how do I do this?:confused:


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=520333

Is this possible?
 

Hi CBrausa

One way, however I used 13 column to get all 39 entries.

Sub CopyIt()
Range("A1").Resize(1, 13).Copy Sheets("Sheet2"). _
Range("A100").End(xlUp).Offset(1, 0)
Range("A1").Offset(0, 13).Resize(1, 13).Copy _
Sheets("Sheet2").Range("A100").End(xlUp).Offset(1, 0)
Range("A1").Offset(0, 26).Resize(1, 13).Copy _
Sheets("Sheet2").Range("A100").End(xlUp).Offset(1, 0)
End Sub

HTH
Regards,
Howard

"CBrausa" wrote in
message ...

I have information in one row, 39 columns, Sheet 1, I want to copy that
info over to Sheet 2, and use 3 rows, 12 columns.
I used EasyFilter to filter my data.
Can & how do I do this?:confused:


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile:
http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=520333

Is this possible?
 

Or if you don't want to start in the second rowon sheet 2, use this:

Sub CopyIt()
Range("A1").Resize(1, 13).Copy Sheets("Sheet2"). _
Range("A100").End(xlUp) '.Offset(1, 0)
Range("A1").Offset(0, 13).Resize(1, 13).Copy _
Sheets("Sheet2").Range("A100").End(xlUp).Offset(1, 0)
Range("A1").Offset(0, 26).Resize(1, 13).Copy _
Sheets("Sheet2").Range("A100").End(xlUp).Offset(1, 0)
End Sub

HTH
Regards,
Howard

"CBrausa" wrote in
message ...

I have information in one row, 39 columns, Sheet 1, I want to copy that
info over to Sheet 2, and use 3 rows, 12 columns.
I used EasyFilter to filter my data.
Can & how do I do this?:confused:


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile:
http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=520333