Navi_G
Board Regular
- Joined
- May 30, 2018
- Messages
- 94
- Office Version
- 2016
- Platform
- Windows
Dear All Experts,
I have a data which i want to copy paste in other sheet for which i make following VBA code but its not working plz provide help.
VBA Code:
Actual Data:
Needed output:
I have large files of this type of data given data is only a smaller piece.
I have a data which i want to copy paste in other sheet for which i make following VBA code but its not working plz provide help.
VBA Code:
VBA Code:
Sub Rangeo()
Dim r1 As Range
For y = 1 To 12
For x = y To 16 Step 4
Set r1 = Range(Cells(1, y), Cells(11, x))
r1.Select
Next x
Next y
Range("A1").Select
End Sub
Line # | Plan | SAM | QTY | Line # | Plan | SAM | QTY | Line # | Plan | SAM | QTY |
1 | 15054 | 15.2 | 150 | 2 | 15066 | 44 | 1100 | 3 | 15071 | 34 | 555 |
1 | 15055 | 46 | 157 | 2 | 15067 | 46 | 157 | 3 | 15072 | 46 | 157 |
1 | 15056 | 44 | 88 | 2 | 15068 | 44 | 88 | 3 | 15073 | 44 | 88 |
1 | 15057 | 51 | 277 | 2 | 15069 | 51 | 277 | 3 | 15074 | 51 | 277 |
1 | 15058 | 55 | 2554 | 2 | 15070 | 55 | 2554 | 3 | 15075 | 55 | 2554 |
1 | 15059 | 44 | 414 | 2 | 15071 | 55 | 414 | 3 | 15076 | 55 | 414 |
1 | 15060 | 14 | 447 | 2 | 15072 | 14 | 447 | 3 | 15077 | 14 | 447 |
1 | 15061 | 41 | 77 | 2 | 15073 | 41 | 77 | 3 | 15078 | 41 | 77 |
1 | 15062 | 22 | 145 | 2 | 15074 | 22 | 145 | 3 | 15079 | 22 | 145 |
1 | 15063 | 34 | 144 | 2 | 15075 | 34 | 144 | 3 | 15080 | 34 | 144 |
1 | 15064 | 44 | 144 | 2 | 15076 | 44 | 144 | 3 | 15081 | 44 | 144 |
1 | 15065 | 44 | 55 | 2 | 15077 | 44 | 55 | 3 | 15082 | 44 | 55 |
Line # | Plan | SAM | QTY |
1 | 15054 | 15.2 | 150 |
1 | 15055 | 46 | 157 |
1 | 15056 | 44 | 88 |
1 | 15057 | 51 | 277 |
1 | 15058 | 55 | 2554 |
1 | 15059 | 44 | 414 |
1 | 15060 | 14 | 447 |
1 | 15061 | 41 | 77 |
1 | 15062 | 22 | 145 |
1 | 15063 | 34 | 144 |
1 | 15064 | 44 | 144 |
1 | 15065 | 44 | 55 |
Line # | Plan | SAM | QTY |
2 | 15066 | 44 | 1100 |
2 | 15067 | 46 | 157 |
2 | 15068 | 44 | 88 |
2 | 15069 | 51 | 277 |
2 | 15070 | 55 | 2554 |
2 | 15071 | 55 | 414 |
2 | 15072 | 14 | 447 |
2 | 15073 | 41 | 77 |
2 | 15074 | 22 | 145 |
2 | 15075 | 34 | 144 |
2 | 15076 | 44 | 144 |
2 | 15077 | 44 | 55 |
Line # | Plan | SAM | QTY |
3 | 15071 | 34 | 555 |
3 | 15072 | 46 | 157 |
3 | 15073 | 44 | 88 |
3 | 15074 | 51 | 277 |
3 | 15075 | 55 | 2554 |
3 | 15076 | 55 | 414 |
3 | 15077 | 14 | 447 |
3 | 15078 | 41 | 77 |
3 | 15079 | 22 | 145 |
3 | 15080 | 34 | 144 |
3 | 15081 | 44 | 144 |
3 | 15082 | 44 | 55 |