 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / April 2008PLEASE 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. 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. > Hi, i want formula in column F cells that if "A1&B1&C1&D1" values > come [quoted text clipped - 4 lines] > all > text "X" rows. 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. > Why write a function and a macro when the macro can do everything??? Have > the macro do your comparisons and delete the row. [quoted text clipped - 12 lines] > > all > > text "X" rows. > 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 [quoted text clipped - 22 lines] > > - 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.