inventory valuation with FiFO method
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...
Attachment | Size |
---|---|
datafile.xls | 97.5 KB |
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 495 guests online.
New Excel Experts
Current Excel / VBA Jobs |
inventory valuation with FiFO methodi 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...
|
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
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 !