S
smandula
The following code copies only one line from Sheet2 to Sheet1.
How can you loop the macro to copy all data in Sheet2 to Sheet1?
What the Macro does is copies Date and 7 numbers to Sheet1. The seven
numbers are any numbers to 39 in any order. Arranged to Column Number
such as Col. 'B' would have number 1; Col. 'K' would have number 10;
and so on to number 39 Col. 'AN'.
The problem is looping thur these data rows on Sheet2.
And not just copying one row.
Any Help would be Appreciated
With Thanks
Sub Newer()
Dim rCell As Range
With Sheet1.Range("A2") 'Header row has description row one
For Each rCell In Sheet2.Range("A1:H1")
If IsDate(rCell.Value) Then
'MsgBox rCell.Address & " has " & rCell & " in it" 'Testing
.Value = Sheet2.Range("A1")
Else
.Offset(0, rCell.Value).Value = rCell.Value
End If
Next rCell
End With
End Sub
How can you loop the macro to copy all data in Sheet2 to Sheet1?
What the Macro does is copies Date and 7 numbers to Sheet1. The seven
numbers are any numbers to 39 in any order. Arranged to Column Number
such as Col. 'B' would have number 1; Col. 'K' would have number 10;
and so on to number 39 Col. 'AN'.
The problem is looping thur these data rows on Sheet2.
And not just copying one row.
Any Help would be Appreciated
With Thanks
Sub Newer()
Dim rCell As Range
With Sheet1.Range("A2") 'Header row has description row one
For Each rCell In Sheet2.Range("A1:H1")
If IsDate(rCell.Value) Then
'MsgBox rCell.Address & " has " & rCell & " in it" 'Testing
.Value = Sheet2.Range("A1")
Else
.Offset(0, rCell.Value).Value = rCell.Value
End If
Next rCell
End With
End Sub