+ Reply to Thread
Results 1 to 5 of 5

HELP with FIFO function or code

  1. #1
    Registered User
    Join Date
    03-21-2012
    Location
    Bay Area, California
    MS-Off Ver
    Excel 2011 & 2010
    Posts
    52

    HELP with FIFO function or code

    Hello,

    I maintain a spreadsheet with multiple accounts, and I need to spend against accounts in the order they were received. For example, if my operating expense for August is 56K, I need a function or code that would draw funds from first account, if the account does not have sufficient funds to cover August bill, goto next account and so on until the August bill is covered. If there is a balance from the last account used, it would be applied to the following month.

    Thanks in advance for any help or suggestion!
    /ca

    Screen Shot 2016-08-03 at 9.01.25 AM.png
    Attached Files Attached Files

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

    Re: HELP with FIFO function or code

    Each month a new column will be prepared with the total expense entered in row 2.
    It means the display needs to be updated only for this new month, is it?
    It means also, that if a macro is used we don't need formulas but values ?
    Last edited by PCI; 08-03-2016 at 02:30 PM.
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    03-21-2012
    Location
    Bay Area, California
    MS-Off Ver
    Excel 2011 & 2010
    Posts
    52

    Re: HELP with FIFO function or code

    Quote Originally Posted by PCI View Post
    Each month a new column will be prepared with the total expense entered in row 2.
    Yes, new column each month
    Quote Originally Posted by PCI View Post
    It means the display needs to be updated only for this new month, is it?
    Yes.
    Quote Originally Posted by PCI View Post
    It means also, that if a macro is used we don't need formulas but values ?
    that is correct.

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

    Re: HELP with FIFO function or code

    See next code
    Please Login or Register  to view this content.

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

    Re: HELP with FIFO function or code

    A remake to treat also the first column which was not done

    Please Login or Register  to view this content.

+ 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. Replies: 3
    Last Post: 10-17-2015, 11:35 AM
  2. Fifo with the change of code
    By makhdoomliaqat in forum Excel General
    Replies: 6
    Last Post: 04-16-2015, 04:08 AM
  3. Fifo costing based on item code
    By Mohamad Mneimneh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2014, 10:17 AM
  4. FIFO-LIFO UDF function not working if DataRange are apart from each other
    By Par in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2014, 06:02 PM
  5. Code to evaluate FIFO for multiple items and dates.
    By BillRush in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2011, 11:09 PM
  6. FIFO Calculation Help using Function
    By edwoody in forum Excel General
    Replies: 2
    Last Post: 04-01-2011, 10:15 AM
  7. FIFO Function
    By aromaveda in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2009, 04:15 PM

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