+ Reply to Thread
Results 1 to 1 of 1

Allocate amount based on Invoices

  1. #1
    Registered User
    Join Date
    08-24-2015
    Location
    Hyderabad, India
    MS-Off Ver
    MS 365
    Posts
    27

    Allocate amount based on Invoices

    Hi,

    I'm trying to look for a VBA where-in I have 2 set of data namely Data 1 - Invoices & Data 2 - Receipts.

    The VBA should allocate all the receipts with the Invoices serial no. wise.

    If a single receipt is not sufficient to adjust a Invoice, a row is inserted and in that row the remaining balance of invoice is adjusted against next receipt.

    I have attached a sample xls for easy reference with the above scenarios.

    Thanks in advance!
    Attached Files Attached Files

+ 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. [SOLVED] Allocate Amount for Month
    By Billy Spivy in forum Excel General
    Replies: 1
    Last Post: 01-24-2018, 03:55 PM
  2. Finding sum of invoices for Total Amount received.
    By ebincharles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2016, 03:56 PM
  3. Create a formula to allocate the amount into appropriate cells
    By kevin211288 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-02-2016, 06:35 PM
  4. To find exact invoices from list that matches receipt amount.
    By nitinmb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2016, 05:35 AM
  5. [SOLVED] Need to find a negative amount and match it to the positve amount based on Acct# and Date
    By sbrandhorst in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-07-2016, 07:49 PM
  6. Need Macro to find match for invoices. With the Amount
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 11-22-2012, 08:03 AM
  7. How can I calculate amount of time left based on amount spent?
    By KLD in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2006, 11:25 AM

Tags for this Thread

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