Hi Friends, I needs to Identify the Closing stock based on part numbers from the Purchase and sales transactions .
And then i need to identify the closing stock which is lying over 60 days in the inventory. *Example:* * * I purchased Part number "XYZ' *70* Nos on 1of Jan'11and *30* Nos on 15th of Feb'11 Sold *60* till 31st march '11 and balance *40* nos on 31st March 2011. In that *40 *Nos *10 *nos over 60 days stock. I have attached sheet which contains purchase and sales sheet with Summary which we needs to prepare. I have taken 3rd Sep 2011 is Base date in this working. can anybody help to get VBA code for preparing Summary sheet! Pzl revert back if you have any doubt on this. Regards, Prabhu -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Closing stock details.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
