Hello Guys !
I have a list of items with codes, quantity and expiry dates, it s basically my stock inventory.
To fit in my reporting format, i need to have one row per code with the different expiry date and quantity at the end of the rows :
Item A 500 31/12/2014
Item A 300 31/01/2015
Item A 200 31/05/2015
Item B 500 30/16/2014
Item B 300 30/04/2015
Item A 500 31/12/2014 300 31/01/2015 200 31/05/2015
Item B 500 30/16/2014 300 30/04/2015
Ideally i would also like to have the sum for each row.
Item A 1000 500 31/12/2014 300 31/01/2015 200 31/05/2015
Item B 800 500 30/16/2014 300 30/04/2015
I m not skilled enough in VBA to do this, Does anybody have an idea ?
Cheers
I ve another thread at : http://www.mrexcel.com/forum/excel-q...ml#post3421706
Bookmarks