PLEASE CAN ANYBODY HELP WITH MACRO
 

Hi, i want formula in column F cells that if "A1&B1&C1&D1" values
come
together again in same row in any row of column (A:D) and if they
have
Dr and Cr figures of same amount in same row in column E cells then
text "X" should appear elase "" . And then i need macro to delete
all
text "X" rows.

PLEASE CAN ANYBODY HELP WITH MACRO
 

Why write a function and a macro when the macro can do everything??? Have
the macro do your comparisons and delete the row.

What do you mean "Come Together"?.
How can column E have Cr and Dr amounts?

The request is confunssing.

"K" wrote:

Hi, i want formula in column F cells that if "A1&B1&C1&D1" values
come
together again in same row in any row of column (A:D) and if they
have
Dr and Cr figures of same amount in same row in column E cells then
text "X" should appear elase "" . And then i need macro to delete
all
text "X" rows.

PLEASE CAN ANYBODY HELP WITH MACRO
 

He means that when the credit (CR) amount cancels the debit (DR) amount they
come together? Don't you understand Brit talk Joel? <g Apparently it is a
journal listing so the debits and credits are listed in the same column. I
gave him some code to match column A and B criteria and delete the rows if
column C equaled zero for the one's that "came together", but for some reason
it didn't work on his system. I modified it to trim spaces, but don't know
if he tried that or not.

"Joel" wrote:

Why write a function and a macro when the macro can do everything??? Have
the macro do your comparisons and delete the row.

What do you mean "Come Together"?.
How can column E have Cr and Dr amounts?

The request is confunssing.

"K" wrote:

Hi, i want formula in column F cells that if "A1&B1&C1&D1" values
come
together again in same row in any row of column (A:D) and if they
have
Dr and Cr figures of same amount in same row in column E cells then
text "X" should appear elase "" . And then i need macro to delete
all
text "X" rows.

PLEASE CAN ANYBODY HELP WITH MACRO
 

On 26 Apr, 23:17, JLGWhiz wrote:
He means that when the credit (CR) amount cancels the debit (DR) amount they
come together? *Don't you understand Brit talk Joel? <g *Apparently it is a
journal listing so the debits and credits are listed in the same column. *I
gave him some code to match column A and B criteria and delete the rows if
column C equaled zero for the one's that "came together", but for some reason
it didn't work on his system. *I modified it to trim spaces, but don't know
if he tried that or not.



"Joel" wrote:
Why write a function and a macro when the macro can do everything??? *Have
the macro do your comparisons and delete the row.

What do you mean "Come Together"?.
How can column E have Cr and Dr amounts?

The request is confunssing.

"K" wrote:

Hi, i want formula in column F cells that if "A1&B1&C1&D1" values
come
together again in same row in any row of column (A:D) and if they
have
Dr and Cr figures of same amount in same row in column E cells then
text "X" should appear elase "" . *And then i need macro to delete
all
text "X" rows.- Hide quoted text -

- Show quoted text -

sorry joel i wasn't good enough to explain my question to you but
JLGWhiz has solved my problem. Thanks lot JLGWhiz my friend your code
is working superb. I have tested it on a sample sheet and it working
good. i'll go back to my office on Monday and will try this on
Original Sheet and if i have any question then i'll come back to you.
Many Thanks again