| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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. |
|
#4
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
| How do I display data from multiple worksheets in a summary sheet. | Excel Discussion (Misc queries) | |||
| Summarizing Data across Worksheets using a single reference | Excel Worksheet Functions | |||
| Need Formula to display pivot table source data | Excel Worksheet Functions | |||
| Macro does not run when data refreshed | Excel Discussion (Misc queries) | |||
Linear Mode
