Search results

Thank you

I altered this myself like the way you did, Thank u

Thank you so much @AliGW

Attached is the picture, where when I am writing a phrase = "The month of " & S4 its not giving me date in that format. Kindly help me fix this.

Dear Sir, Apologies I couldn't reply you that day. Yes your solution was right to my post, https://chandoo.org/forum/threads/comparing-the-column-and-highlighting-the-same-number.37745/#post-226706, can you teach me if I want to apply that to a large set of data. Thanks you so much Regards, Rafay

I dont think so, as sum of the highlighted amounts in debit and credit should be equal. See 86.49 is twice in Credits and once in Debits, 86.49 should get highlighted once in each debit and credit leaving one unhighlighted in credits,

I am new to chandoo, I thought to post it to both Macro and Excel question forum.

I tried to record a macro, which did not worked, but yes you are right. I have matching numbers in different rows. Attached is the document.

Thank Hui. Narayan is right its not working when the match is in different rows. Also, I have different set of data, in the attachment. can you help me in this case also?

Hi All, I tried to construct a macro to compare the two columns and highlight them. Any other good alternative would be appreciated. Guidelines are also there in the attached sheet. Thanks

Hi All, Attached is the file, I have to compare two columns and highlight both the columns. Further guidelines are in the Sheet. Thanks

Hi All, I tried to write its Macro, but there were a lot of issues faced. I am inserting data in (Nov-17) tab and then if the particular is "a", I go to the worksheet "a" and copy the row from (Nov-17) to worksheet "a". Same goes on with "b" & "c". Also, attached is the sheet. Thanks

Frequently I change the Input .Tab, I am having issue when I am calculating totals, the row is fixed to Row 58, I want the macro to select the last row. Moreover, its a RECORDED MACRO, can this be modified. Thanks

Hi All, I want to alter this Macro as for the Sum Total I have to select the ( LAST ROW + 1 ). Also attached is the sheet, for any inconvenience. Thanks Sub FMLdailyREPORT() Range("D2").Select ActiveCell.FormulaR1C1 = "$" Range("E2").Select Range(Selection...

I can not see the green marker, I have office 2016

Yes this works, but I was in search of something better than this

Its not working. Issues in the sum total

Hi All, Attached is the sheet, where I am not able to convert the given value (I can not clearly identify its a text or something else) to number sue to which I am not able to calculate totals. Thanks

Thanks Hui, Its a recorded Macro can this be improved anyway?

Thanks NARAYN, Can you tell me what this "<>" means?

Thank you so much This really worked

Hi All, Attached is the Code, Where I have issues in the Last part when the statement copies to Macro Workbook, "Bnk Stmnt" tab, the copied cells don't go to the last cells to paste the selected statement. Thanks Sub COPYtoBNKSTMNT() ' ' COPYtoBNKSTMNT Macro ' ' Columns("A:A").Select...

I opened an Input Query, Browsed the Folder location of the file, used Combine Binaries. The above mentioned is what I generally Follow. Also, Attached is the sheet, showing how I want the result after its merging. Thanks

Hi All, While merging these two files using power query its given a DATA FORMAT error, Can anybody help me out in with this error. Thanks

Hi All, Attached is the sheet, where there are totals of Individual people. What is the EASIEST WAY to sum up all highlighted totals in the given sheet, as I have plenty of data like this. Thanks