Hi Rajan, In Report sheet "C" column "Purchases" has to taken from purchases sheet against particular part number mentioned in the column "A" and total qty purchased.It may me more then one line items.
Similarly Closing stock and Sales also we have to take total cl stock and total sales against the particular part number. Now we are doing manually finding the total Purchases or sales and Cl stock using filter and we are totaling all the Qty purchases or sold. Example for Part number "412911-B21" we have to go to purchases sheet and filter it in "H" Column and see the total qty purchased I.e. 10 nos. and mentioned it in Report column "C" (Purchases). for sales and Cl stock also we are doing in similar way only. 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