Home » Forums » Open Source Learning Center » Question and Answer

inventory valuation with FiFO method

mahaveersomani's picture
Submitted by mahaveersomani on 19 February, 2013 - 09:50

i have 5 issues with the attached file

all the issues are mentioned in my attached file

any help will be much appreciated...

Thanks in advance...

AttachmentSize
datafile.xls97.5 KB
‹ Seprate Data with the help of VBA code bisection vba code ›
»
Nick's picture

hiyour question will take me

Submitted by Nick on 26 February, 2013 - 08:33.

hi
your question will take me too long to pick apart, but having a brief look at your sheet, the basic problem is one of design
- if you store your data in a tabular format with 1 row per item, you can then use a pivot table to generate (almost) any report you need.

more here:
http://excelexperts.com/Excel-Tips-Pivot-Tables-for-dummies

p.s. loving that profile pic !

»