VBA copy details to another excel

[vozshmily]

Good Day everyone,

I'm new on VBA but i badly need this code.

copy certain details in one excel in random postion [=sum(e1:xx)] and a positive number not zero

i like to put in on a certain excel and on a certain cell the 2 details

hope someone can help

 

[MrTeeny]

Think you need to be a lot more clearer about exactly what you want.

Copying cells can be as simple as Range("A1").Value = Range("B1").Value. I'm not sure what you mean by in one excel and putting it on a certain excel, so you mean a new cell , new worksheet or even in an entirely new workbook.

You can generate random numbers easily enough, using Int ((100 - 1 + 1) * Rnd + 1) gives a random number between 1 and 100. So with all these parts you can use it to generate a random cell to copy into a random cell in another workbook if needed.

 

[vozshmily]

[TABLE="width: 329"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD] Transfers [/TD]
[TD]Fee[/TD]
[TD]Balance[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]48.78[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]48.78[/TD]
[/TR]
[TR]
[TD="align: right"]-1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]47.78[/TD]
[/TR]
[TR]
[TD="align: right"]-2[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]45.78[/TD]
[/TR]
[TR]
[TD="align: right"]-3[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]42.78[/TD]
[/TR]
[TR]
[TD="align: right"]-4[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]38.78[/TD]
[/TR]
[TR]
[TD="align: right"]-5[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]33.78[/TD]
[/TR]
[TR]
[TD="align: right"]-6[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]27.78[/TD]
[/TR]
[TR]
[TD="align: right"]-7[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]20.78[/TD]
[/TR]
[TR]
[TD="align: right"]-8[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12.78[/TD]
[/TR]
[TR]
[TD="align: right"]-9[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3.78[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3.78[/TD]
[/TR]
[TR]
[TD="align: right"]-45[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]-41.22[/TD]
[/TR]
</tbody>[/TABLE]


this is an example... the -45 is =sum(e1:eXXX) i need to copy that and put it on a specific excel location example B12...then the 3.78 i need to copy it too and put on a specific excel location too example J10...without opening the excel file

 

[vozshmily]

i made a workbook for consolidation i need to copy the files under each workbook...