Macro for Contra entry

[ravichandavar]

I don't think there can be an answer to your question. Consider this data...

	A	B
1	Remain amount	Supplier
2	25	A
3	75	A
4	50	A
5	50	A
6	25	A
7	-125	A

Anyone of the following would meet your conditions; how would we know which one is correct?

	D	E	F	G	H	I	J	K
1	Remain amount	Supplier		Remain amount	Supplier		Remain amount	Supplier
2	25	A		25	A		25	A
3	75	A		75	A		75	A
4	50	A		50	A		50	A
5	50	A		50	A		50	A
6	25	A		25	A		25	A
7	-125	A		-125	A		-125	A

Is there anything tying the amounts together (like an Invoice Number or something)?

HI,

First of all its OK for me if it picks any line which adds to zero.Secondly Yes there is Invoice and doc no but its useless, but there is one thing we can take document date. We can knock off with the Document dates which falls firs...

Thanks,
Ravi.C