Recent content by sgmpatnaik

Gateway2026 Thanks for Your Support and kind heart, i have downloaded the file which you given me i will check to day night because i have some pending returns to complete them and just i checked not gone through 21AADFK6145K1ZG Kausalya Agencies 3840 1235.52 1595.52 -360...

Hi, Good Morning, we got 95 % success the 5 % is missed, i am explaining you clearly that is we entered the invoices 3476, and 3477 in two times and the invoice totals are not matched with the 2B figures so we marked with mismatch and Multi Entries found. the Invoice Number 3840 also entered in...

@Gateway2026 Hi i need one suggestion from you that is when i am doing the reconciliation for the clients then i noticed one thing that is if there is single invoice entered multiply times for same value then it's summing but i am thinking some different, for your knowledge i have explain the...

@Gateway2026 Good Morning, Thank You For Your Support and it's works perfect as i think, i feel very glad @vletm Good Morning, Thank You for Your Replay, at present i have not tested your code but sure i will test and inform you the same, can you please elaborate how it is handle the...

Ok, i have attached the sample file and i have set one row as updated in the Reconcile Sheet

Aha Thank You, at present the sum / Calculations are correct, Thank You, Can You do a favor for me, actually i am thinking to add the extra option and one another code that is at present we are doing the reconciliation with Tax Part Only now i would like to add one more extra line that is if...

@ Gateway2026 can you please help me to find out the mistake where i am doing, that is when i run the code with your given function then i am facing problem to sum the value of partial invoices which are located in the sheet of Purchase Register . my Reconciliation code is compare the Data...

Ah Great Work the both suggestions, Thank You Friends for your support, i did my job with your support, if any help need then i will knock the door again Thank You

Here i am running a code for Data Reconciliation with sheets that's why i want a function code for GetInvoice Number hope you understand Thank You

Hi, sorry for my delay replay. i completely gone through your sample file and i checked there you have taken a helper column E there we have to mention the ignore methods to get the invoice number, after that if we run the code which you given the button do it then it extract the invoice...

Hi, Good Morning Every One actually i am a tax Consultant and i have to cross check the books of records with GST , I have prepared one excel file to Reconcile the data from GST to Clients Data here i am facing an problem, that is i would like to extract the numbers of GST invoice to numbers...

Hi Some Congrats on your 3k posts you are doing a rocket type job, please keep it up

May be, now it's ok Another Method, Check the below link @Pratap Another Method, Check the below link http://wheatblog.com/2011/11/applying-excel-subtotals-with-vba/

@Mike I Think the file is not uploaded correctly, when try to download then getting a error msg please check

@balkrishna Which links you have submitted they are requesting to take permission from you The forum members or Ninja's never take any permission to Help if you want to solve your problem please upload the correct file from Drop Box and speedshare etc and Thanks