+ Reply to Thread
Results 1 to 4 of 4

Using FIFO Formula on a Worksheet

  1. #1
    Registered User
    Join Date
    10-29-2009
    Location
    Charlotte, NC
    MS-Off Ver
    MAC Excel 2010
    Posts
    3

    Using FIFO Formula on a Worksheet

    I have a spreadsheet for which I am trying to calculate the cost of inventory on hand at any given time. This will use the first in first out methodology of inventory, if anyone cares! I have found VBA code online that I believe will work but I do not know how to adapt this code to my spreadsheet. Can anyone please give me an idea or help me put this code in the spreadsheet?

    Below I have captured the VBA code I am trying to utilize. In the excel file, Inventory Calc tab, cell F9 is where I would want the spreadsheet to calculate what the price per unit of inventory should be. The information will come from the Order Entry tab. Let me know what additional information will be useful.

    Option Explicit
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by hdanger10; 12-27-2012 at 02:38 PM. Reason: Added attachment

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Using FIFO Formula on a Worksheet

    Hi,

    You may not necessarily need a macro to calculate this. Standard Excel functions will probably do.
    Upload your workbook so that we can see the request in context
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Using FIFO Formula on a Worksheet

    Hello hdanger10,

    Welcome to the Forum!

    I changed your title to better describe your problem. It is obvious you come here for help, so there is no need to put that in your title. Describing your problem accurately will get you answers much more quickly since members will know if they can answer your question or not.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  4. #4
    Registered User
    Join Date
    10-29-2009
    Location
    Charlotte, NC
    MS-Off Ver
    MAC Excel 2010
    Posts
    3

    Re: Using FIFO Formula on a Worksheet

    Thought I had included attachment - now it is updated.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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