Matching Macro, Matching Dr. to Cr.

**kartikeyadawar** · 12-15-2012, 05:21 AM

Hey guys ,
Need Help creating a Macros on Excel
One colum i have amounts and the other colum had debits or credits.

What i want is when i run the macro same amounts to be highlighted eg 100 dr gets highlighted and 100 credit

Attaching a file for reffrence

Please help

THXBook1.xlsx

**HSV** · 12-15-2012, 07:59 AM

Try it once.
Suppose "Debit" number rather than "Credit".

Please Login or Register  to view this content.

**event21** · 12-15-2012, 08:35 AM

Hi -

First of all, glad you managed to post your own thread.
Try whatever comes first debit or credit

Please Login or Register  to view this content.

Regards,
Event

**kartikeyadawar** · 12-15-2012, 09:01 AM

Guys u are the best

Thank You so much , u guys are so awsome ..:p

Thank You

btw i dint select any thing just inserted module and past it there and run it...
And it worked
thx again guys

**kartikeyadawar** · 12-15-2012, 09:04 AM

one more question:

on my actual sheets the amount and debit credit colum are in between ....so before running this do i need to select any thing ???

and wats the diff between the two coding which u guys have posted are the both same ?

Thx

**kartikeyadawar** · 01-12-2013, 02:14 AM

guys one more thing is required , i need ur help for that.

Tha macro is fine, I want one more thing added to it.
Third colum would have account no . I want the dr to match cr only if the account number is same.

Colum name would be "Original Description" .Book1 (4).xlsx

Thanks

**kartikeyadawar** · 01-12-2013, 03:44 PM

Guys, I want
I want that Cr 100 to match to dr 100 only if the acc number is the same.

Third colum would have account no . I want the dr to match cr only if the account number is same.

Colum name would be "Original Description" .Book1 (4).xlsx

Attaching the file for ref tBook1 (4).xlsxhanks

Thanks

**xladept** · 01-12-2013, 09:08 PM

Hi,

Is this what you wanted, is it even what you requested??

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code into the white space on the right

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

**kartikeyadawar** · 01-12-2013, 11:16 PM

Book1 (4).xlsmHey i tried running it .
I pressed F11 , VB opened i inserted the module and paste the code and pressed f11 to close it then f8 to run the macro . It took me back to the coding and one line got highlighted in yellow.

Iam attaching the file for reffrence , please see it once youll understand. Thanks for helping out . Appreciate it.

Thanks

**kartikeyadawar** · 01-12-2013, 11:34 PM

Guys please.

Thanks

**xladept** · 01-13-2013, 01:12 AM

F8 is for single stepping - if you want to just run the routine , hit F5!

**kartikeyadawar** · 01-13-2013, 03:01 AM

Thanks alot brother. Really appreciate your help

**kartikeyadawar** · 01-13-2013, 05:59 AM

Book1 ().xlsx

Dude ,
I entered two amount '77.24' one debit one credit. with same account number. It din't turn green (it should have matched)

Attaching the file . Please check the last two amounts . Sorry for the trouble.

Thanks

**xladept** · 01-13-2013, 03:16 PM

You're welcome, for the new values just change the Amt declaration(in red):

Please Login or Register  to view this content.

Thanks for the rep!

**kartikeyadawar** · 01-13-2013, 04:06 PM

Thanks Buddy

you'r the best

**xladept** · 01-13-2013, 04:28 PM

You're welcome!

**kartikeyadawar** · 01-14-2013, 04:04 AM

Bro please help

Acct = Range("C" & i):

Is turning yellow .

**xladept** · 01-14-2013, 12:41 PM

Try single stepping (F8) and see if the value of i is legitimate. Or, post a sample of the book which has this problem.

**kartikeyadawar** · 01-14-2013, 12:58 PM

match Macro.xlsm

file attached.

One more thing i want that the matched entry cell should turn green instead of the font. Its a little easier to spot.

Thanks

**xladept** · 01-14-2013, 03:48 PM

Well, that really isn't an Account Number - but this should work, I used a lighter Green:

Please Login or Register  to view this content.

**kartikeyadawar** · 01-14-2013, 11:40 PM

Dude thanks alot for all the help.

Really appreciate it.

If you don't mind can u share your email address, if i have any problems i can contact u directly.
Thanks again

**xladept** · 01-15-2013, 12:19 AM

You're welcome.

Matching Macro, Matching Dr. to Cr.

LinkBack

Thread Tools

Rate This Thread

Display

Matching Macro, Matching Dr. to Cr.

Re: Matching Macro, Matching Dr. to Cr.

Re: Matching Macro, Matching Dr. to Cr.

Re: Matching Macro, Matching Dr. to Cr.

Re: Matching Macro, Matching Dr. to Cr.

Re: Matching Macro, Matching Dr. to Cr.

Macro Matching Dr to Cr,

Re: Macro Matching Dr to Cr,

Re: Macro Matching Dr to Cr,

Re: Matching Macro, Matching Dr. to Cr.

Re: Macro Matching Dr to Cr,

Re: Matching Macro, Matching Dr. to Cr.

Re: Matching Macro, Matching Dr. to Cr.

Re: Matching Macro, Matching Dr. to Cr.

Re: Matching Macro, Matching Dr. to Cr.

Re: Matching Macro, Matching Dr. to Cr.

Re: Matching Macro, Matching Dr. to Cr.

Re: Matching Macro, Matching Dr. to Cr.

Re: Matching Macro, Matching Dr. to Cr.

Re: Matching Macro, Matching Dr. to Cr.

Re: Matching Macro, Matching Dr. to Cr.

Re: Matching Macro, Matching Dr. to Cr.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions