PLEASE CAN ANYBODY HELP WITH MACRO

[K]

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

 

[Joel]

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.

 

[JLGWhiz]

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.

 

[K]

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.








- 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