Macro for Contra entry

Hi,

I need a macro which highlights the Debit and credit amounts for a vendor.
For example. I have two columns with vendor and Amount.Suppose Vendor A contains 5 or more rows which may contain debit and credit which is summing to Zero.

Please find the attachment where I have highlighted with yellow colour which needs to be highlighted using macro.

Regards,
Ravi

Quote:

---

Originally Posted by ravichandavar

Hi,

I need a macro which highlights the Debit and credit amounts for a vendor.
For example. I have two columns with vendor and Amount.Suppose Vendor A contains 5 or more rows which may contain debit and credit which is summing to Zero.

---

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)?

Quote:

---

Originally Posted by Rick Rothstein

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