inventory valuation with FiFO method

mahaveersomani's picture

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
Nick's picture

hiyour question will take me

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 !