find result from two sheet
 

I have two sheet have similar numbers, I want combine them ASAP. The
struction like this :

First Sheet (2004) :

Product QTY
Apple 2
pearl 4
milk 5

second sheet (2005)

Product QTY
Apple 5
pearl 3
sugar 5


I hope can get result like this :
Product 2004 2005
Apple 2 5
pearl 4 3
milk 5 0
sugar 0 5

is there anyone can tell which function can be used to combine , I have
hundreds of lines, if do by manel, I am afraid I need at least one day.

find result from two sheet
 

I'm not sure how simply your lists are but you can highlight whole rows and
whole columns by clicking on the headers at the top and sides. So to
highlight column A then click on the 'A'. This would make it very simple to
copy (Ctrl+C) and paste (Ctrl+V) large amounts of data into another sheet.

find result from two sheet
 

You will need a VBA macro tho achieve this.

I can help

--
AP

"Donna" <Donna @discussions.microsoft.com a écrit dans le message de
...
I have two sheet have similar numbers, I want combine them ASAP. The
struction like this :

First Sheet (2004) :

Product QTY
Apple 2
pearl 4
milk 5

second sheet (2005)

Product QTY
Apple 5
pearl 3
sugar 5


I hope can get result like this :
Product 2004 2005
Apple 2 5
pearl 4 3
milk 5 0
sugar 0 5

is there anyone can tell which function can be used to combine , I have
hundreds of lines, if do by manel, I am afraid I need at least one day.