find result from two sheet

[Guest]

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.

 

[Guest]

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.

 

[Ardus Petus]

You will need a VBA macro tho achieve this.

I can help