how to combine two similiar sheet
pls advise which functions should be used if I want to combine below two sheet
Sheet One 2004
Product qty
milk 2
apple 3
pearl 4
sheet two 2005
Product qty
Sugar 2
apple 3
pearl 4
I hope get result like this
Product 04 qty 05 qty
milk 2 0
apple 3 3
pearl 4 4
Sugar 0 2
thanks.
|