Search : in
By :

How do I Copy Two Cell Ranges to New Blank 2

Last answer on Apr 14, 2009 4:58:14 am BST monocat, on Apr 13, 2009 7:20:23 pm BST 
 Report this message to moderators

Hi All- a newbie,

I've been trying to figure this out since yesterday through Excel forums, but to no avail.

This is my basic table I currently have.

Col1 Col2 Col3 Col4 Col5 Col6 Col7
Item1 24 2.00 48 1.50 96 1.00
Item2 24 3.00 48 2.50 96 2.00

I want to be able to use a macro and do the following for everyrow in the Worksheet. Basically copy two different ranges and paste in new rows.

Col1 Col2 Col3
Item1 24 2.00
Item1 48 1.50
Item1 96 1.00
Item2 24 3.00
Item2 48 2.50
Item3 96 2.00

Any help is appreciated.

Best answers for « How do I Copy Two Cell Ranges to New Blank 2 » in :
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Copy an entire partition on Vista ShowCopy an entire partition on Vista Issue Solution Issue It is possible to copy the entire partition on your hard drive with the DVD of vista. It is very useful if you want to change your hard drive in order to restore all data....
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply

1

 mubashir aziz, on Apr 14, 2009 4:58:14 am BST

Below macro will copy First 3 column of Sheet1 in Sheet 2 .... you can change selection as per your requirements .....


Sub copy_three_col()
'
' This macro will select first 3 column of sheet 1and then copy to Sheet2
'
Columns("A:C").Select
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste
Range("D13").Select


End Sub

   
Reply to mubashir aziz
Ask your question Reply
They need your help