Hello

Can you help with a Macro?

I have now a Macro for printing the information that I have on the Sheet 1.
A B C D E F
1 Ref:
2 3
3 Invoice: Amount:
4 15200 500

Both Ref(A2) and Invoice(E4)/Amount(F4) information changes all the time.
I want a Macro that can look up the reference(A) on the sheet 2 and put in there the info under Invoice(D) and Amount(E):

Sheet 2:
A B C D E
1 Invoice: Amount:
2 1 15198 100
3 2 15199 200
4 3

I also need that the macro adds togheter (or removes if credit) under the amount(E) in the sheet 2.

Is this possible?

I hope somebody can help me.

Regards