How to add two sheets in a new sheet using VBA
 

Hi all,

Need a favour as usual.

I have two sheets (sheet1 & sheet2) each with data and the same reference. I
want with a click of a button to input in sheet3 the sum of each
corresponding cells i.e. sheet3 cell 1 = sheet1 cell 1 + sheet2 cell 1 and
in cell 0 show the reference. Note formula has to look at all cells within a
range say "database".

Sheet3 results can vary i.e. one time there can be 10 rows and 5 columns
other times it could be 2 rows and 10 columns.

Sheet 1 data Sheet 2 data
1995 A 1,000 1,500 1995 A 500 200
1995 B 1,100 1,600 1995 B 600 1,100
1995 C 1,200 1,700 1995 C 700 1,200
1995 D 1,300 1,800 1995 D 800 1,300
1995 E 1,400 1,900 1995 E 900 1,400
Sheet 3 Data
1995 A 1,500 1,700
1995 B 1,700 2,700
1995 C 1,900 2,900
1995 D 2,100 3,100
1995 E 2,300 3,300


Looking for you smart people to help me out.....
Thanks
Pantelis