+ Reply to Thread
Results 1 to 10 of 10

Reconciliation of Sum

  1. #1
    Registered User
    Join Date
    09-15-2015
    Location
    London
    MS-Off Ver
    Windows 7
    Posts
    43

    Reconciliation of Sum

    Dear Colleagues,

    Could you be kind to find where is the problem in this below coding:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Eltun; 06-25-2018 at 06:04 AM.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,492

    Re: Reconciliation of Sum

    Eltun,
    It seems you forgot the code tags when posting your code, please review your thread and adjust it.
    In the other hand it will easier if you attach an Excel sample to check you code
    PCI
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    09-15-2015
    Location
    London
    MS-Off Ver
    Windows 7
    Posts
    43

    Re: Reconciliation of Sum

    Dear PCI,

    Hope I have correctly used Code tag now. And attached Excel file for your convenience.

  4. #4
    Registered User
    Join Date
    09-15-2015
    Location
    London
    MS-Off Ver
    Windows 7
    Posts
    43

    Re: Reconciliation of Sum

    now should be good) thanks for your patience!
    btw, I have tried to pay for commercial services, but couldnt over paypal as I am trying to pay via my Russia payment card.
    Is there anyway to pay directly.

  5. #5
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,611

    Re: Reconciliation of Sum

    I think we can solve your problem here for free--but you have not said what the problem is.
    Could you be kind to find where is the problem in this below coding:
    What is the problem? What do you want to happen? What is happening instead?

  6. #6
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,611

    Re: Reconciliation of Sum

    The code in your file has more than what you show here, which might be the problem.
    Please Login or Register  to view this content.
    Your code will always flow down to the MsgBox and give an error message. When using On Error GoTo with a label, you usually must preface the label:
    Please Login or Register  to view this content.
    This may not be the only problem, but I don't don't know what you want your code to do.

  7. #7
    Registered User
    Join Date
    09-15-2015
    Location
    London
    MS-Off Ver
    Windows 7
    Posts
    43

    Re: Reconciliation of Sum

    Thank you for your reply. In code i used go to eh: label when there is a error. Code is not going eh: label where the code is working true.

    In this excel my purpose is to sum all quantities with same names to backward.

  8. #8
    Registered User
    Join Date
    09-15-2015
    Location
    London
    MS-Off Ver
    Windows 7
    Posts
    43

    Re: Reconciliation of Sum

    I have updated the code, could you be kind to check for this one:

    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    09-15-2015
    Location
    London
    MS-Off Ver
    Windows 7
    Posts
    43

    Re: Reconciliation of Sum

    HI Sir,

    Can you check for the latest code pls

  10. #10
    Registered User
    Join Date
    09-15-2015
    Location
    London
    MS-Off Ver
    Windows 7
    Posts
    43

    Re: Reconciliation of Sum

    Friends,
    Do you have any suggestions ?
    please assist

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Reconciliation Help
    By giryan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2017, 03:34 PM
  2. Bank Reconciliation Sum If
    By japj1984 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-21-2016, 06:21 PM
  3. Reconciliation
    By musema in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-17-2015, 01:54 PM
  4. Reconciliation
    By Shihab in forum Excel General
    Replies: 2
    Last Post: 01-12-2014, 12:21 PM
  5. Reconciliation
    By Eduard in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-22-2008, 05:05 AM
  6. Reconciliation
    By cmt_london in forum Excel General
    Replies: 1
    Last Post: 02-19-2008, 09:14 AM
  7. Reconciliation
    By Eduard in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2005, 11:01 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1