Macro Copy Data to Another Sheet With Specific Cell

[muhammad susanto]

hi all..

this code work properly, how to modify so code work copy to another sheet with specific cell
here this code:

Sub copy()
Sheets("Sheet1").Range("A1:B10").copy
'Activate the destination worksheet
Sheets("Sheet2").Activate
'Select the target range
Range("E1").Select
'Paste in the target destination
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub

i want to destination sheet in spesific range/cell e.g. E1,E3,E6,D2, etc..
any one help give me figure out it, thank in advance
.sst

 

[Joe4]

I am not quite clear on what you are asking.

Are you saying that you want:
- A1 to be copied to E1
- A2 to be copied to E3
- A3 to be copied to E6
...

If not, please walk us through an actual example fully, to show us exactly what you are trying to do.

 

[muhammad susanto]

I am not quite clear on what you are asking.

Are you saying that you want:
- A1 to be copied to E1
- A2 to be copied to E3
- A3 to be copied to E6
...

If not, please walk us through an actual example fully, to show us exactly what you are trying to do.

hi joe4,
i'm sorry, yes you're right A1 to be copied E1, A2 to be copied E3, A3 to be copied E6, A4 to be copied E12 etc...

 

[Joe4]

If you are copying a range of 20 cells, then you need to map each of the 20 to 20 specific cells.
Where is this mapping to be stored (i.e. what cell gets copied to what cell)?