Can any one help me on my project for calculating capital gains & generating closing inventory on FIFO basis from opening stock sheet with columns as A:Name of Scrip, B:Batch no., C:Purchase date, D: quantity, E: Rate, F: Cost Amount and
Transaction Sheet with columns as B:Trade date, D...