Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Sheet to new Sheet and clear cells on original sheets | Excel Discussion (Misc queries) | |||
sort sheets except the first sheet | Excel Discussion (Misc queries) | |||
Copy from sheet one to several sheets | New Users to Excel | |||
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
Allocate Files to Sheets and Build a Master Sheet which Summarises All Sheets | Excel Programming |