PDA

View Full Version : compare few columns of data



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?