How do I add data from two worksheets and display on the third Wks
 

All data are compatible format, and compatible kind in numeric.
I used to know how to add a record on two worksheets and disply on the third
worksheet. I forgot how. If anyone can assist , I would be grateful.

Perhaps you're talking about this?
http://www.officearticles.com/excel/...rk sheets.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"mm" wrote in message
...
All data are compatible format, and compatible kind in numeric.
I used to know how to add a record on two worksheets and disply on the
third
worksheet. I forgot how. If anyone can assist , I would be grateful.

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/consol.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm

The "Bread-Roll" consolidation method - great for accountants. See how
simple it is to consolidate any combination of your organisation's accounts.
(No VBA used)


--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"mm" wrote in message
...
All data are compatible format, and compatible kind in numeric.
I used to know how to add a record on two worksheets and disply on the
third
worksheet. I forgot how. If anyone can assist , I would be grateful.

Hi

On the third worksheet.

=Sheet1!A1+Sheet2!A1


"Anne Troy" wrote in message
news:c775a$42bca296$97c5108d$20764@allthenewsgroup s.com...
Perhaps you're talking about this?

http://www.officearticles.com/excel/...rk sheets.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"mm" wrote in message
...
All data are compatible format, and compatible kind in numeric.
I used to know how to add a record on two worksheets and disply on the
third
worksheet. I forgot how. If anyone can assist , I would be grateful.