benong
04-04-2012, 01:10 AM
hi,
i've this list of data in sheet 1.
eg.
model item Qty
A 1 1pc
A 2 1pc
A 3 2pc
i have another list of data which shows the updated data in sheet 2.
model item Qty
A 1 1pc
A 2 1pc
A 3 2pc
A 5 1pc
B 1 3pc
B 5 2pc
B 8 1pc
C 2 2pc
C 3 3pc
C 6 4pc
Notice that there was 1 new item added to model A.
i want to display those new items in sheet 1, continue at the end of the list.
In another scenario, if some of the items are taken away from model A, i want to display the existing qty as 0.
model item Qty
A 1 1pc
A 2 1pc
A 3 0
A 5 0
B 1 3pc
B 5 2pc
B 8 1pc
C 2 2pc
C 3 3pc
C 6 4pc
How can this be done?
i've this list of data in sheet 1.
eg.
model item Qty
A 1 1pc
A 2 1pc
A 3 2pc
i have another list of data which shows the updated data in sheet 2.
model item Qty
A 1 1pc
A 2 1pc
A 3 2pc
A 5 1pc
B 1 3pc
B 5 2pc
B 8 1pc
C 2 2pc
C 3 3pc
C 6 4pc
Notice that there was 1 new item added to model A.
i want to display those new items in sheet 1, continue at the end of the list.
In another scenario, if some of the items are taken away from model A, i want to display the existing qty as 0.
model item Qty
A 1 1pc
A 2 1pc
A 3 0
A 5 0
B 1 3pc
B 5 2pc
B 8 1pc
C 2 2pc
C 3 3pc
C 6 4pc
How can this be done?