有两个excel表,格式如下
欠料表
Item_ID Shortage_QTY
0001 1000
0001 2000
0001 100
0002 3000
0002 3000
0003 1000
0003 3000
0003 800
0003 10
已发料表
Item_ID Qty Date
0001 300 2012-01-03
0001 800 2012-02-02
0001 3000 2012-01-03
0002 300 2012-04-02
0002 300 2012-01-14
0003 2800 2012-01-02
0003 1000 2012-01-12
0003 800 2012-01-16
0003 100 2012-02-02
需要得到的表
Item_ID Shortage_QTY Pay_Date
0001 1000 "300 "& "2012-01-03 "& "800 "& "2012-02-02 " --此300不够1000分配800数据
0001 2000 "800 "& "2012-02-02 "& "3000 "& "2012-01-03 " --将上面的800分配完,再分配3000的
0001 100 "3000 "& "2012-01-03 " --分配三千未分配完的
0002 3000 "300 "& "2012-04-02 "& "300 "& "2012-01-14 "& "不够分配 "