I am working on a project for an Excel/VBA course that requires us to take purchase/sell data and determine the value of the remaining inventory at the end of the month by 4 methods: averaging, specific ID, LIFO and FIFO.
We are completely stuck on FIFO/LIFO and honestly don't even really know where to begin. If you could look at this and help us out with any of it we would greatly appreciate it.
Anything you can help us with, be it excel formulas or VBA code, would be of great assistance because we are at a complete standstill.
The file is here: Zippyshare.com - IDS 331 Final 11-22 (1).xlsmI didn't know how to put it directly into this since this is my first post.
But pleeeease help us out!
Thank you!
We are completely stuck on FIFO/LIFO and honestly don't even really know where to begin. If you could look at this and help us out with any of it we would greatly appreciate it.
Anything you can help us with, be it excel formulas or VBA code, would be of great assistance because we are at a complete standstill.
The file is here: Zippyshare.com - IDS 331 Final 11-22 (1).xlsmI didn't know how to put it directly into this since this is my first post.
But pleeeease help us out!
Thank you!
