Macro for Contra entry

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

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

Regards,
Ravi

[Rick Rothstein]

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

[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