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]

	Transfers	Fee	Balance
			48.78
			48.78
-1			47.78
-2			45.78
-3			42.78
-4			38.78
-5			33.78
-6			27.78
-7			20.78
-8			12.78
-9			3.78
			3.78
-45			-41.22

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

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...