Receive formula from a different worksheet

[luizmachado]

Please Login or Register  to view this content.

This code above gives me the sum between J7 and J8 in range J10 on sheet1 and in range H10 on sheet2.
If I change J7 value, J10 will change, but H10 won't.

I'm trying to make it work, but don't know how. I was thinking in something like this "code" below:

Please Login or Register  to view this content.

If needed, I uploaded a file with this example below.

Thanks,
Luiz.

[luizmachado]

I made my second example right, but it won't work as I want, I mean, if I change J7 value, H10 in sheet 2 won't change.

This the code I tried:

Please Login or Register  to view this content.

[luizmachado]

I did it!! But not on VBA =(

Please Login or Register  to view this content.

This will pretty much work, but I need it to be on VBA and this code below won't work.

Please Login or Register  to view this content.

Do you know how to do it?

[luizmachado]

I did it!! But not on VBA =(

Please Login or Register  to view this content.

This will pretty much work, but I need it to be on VBA and this code below won't work.

Please Login or Register  to view this content.

Do you know how to do it?

It just worked out of nowhere. But anyway, what I really want won't work.

Please Login or Register  to view this content.

[luizmachado]

Actually, using only =Sheet1!J10 was enough and faster =)