Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Sheet to new Sheet and clear cells on original sheets Boiler-Todd Excel Discussion (Misc queries) 7 September 23rd 09 10:02 PM
sort sheets except the first sheet Bill_S Excel Discussion (Misc queries) 2 April 10th 08 09:19 PM
Copy from sheet one to several sheets lmagne New Users to Excel 1 October 20th 05 03:03 PM
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? Daniel Excel Worksheet Functions 1 July 6th 05 09:57 PM
Allocate Files to Sheets and Build a Master Sheet which Summarises All Sheets hanuman Excel Programming 0 September 9th 03 11:23 AM


All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"