| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tough question moving data (may require macro?)
I have data in columns and rows in different sheets.
Each sheet is the name of a company and contains data about the company. I need a summary sheet. What I want in the summary sheet is: column A: Sheet Name column B: sum(c41,c49) from each sheet column C: sum(d41,d49) from each sheet column D: sum(e41,e49) from each sheet and so on... Any ideas how I would accomplish this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tough question moving data (may require macro?)
This question comes up every once in a while.
=SUM(Sheet1:Sheet3!C1:C45) HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Josh Craig" wrote: I have data in columns and rows in different sheets. Each sheet is the name of a company and contains data about the company. I need a summary sheet. What I want in the summary sheet is: column A: Sheet Name column B: sum(c41,c49) from each sheet column C: sum(d41,d49) from each sheet column D: sum(e41,e49) from each sheet and so on... Any ideas how I would accomplish this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I require data entry in a cell before moving to the next ce | Excel Worksheet Functions | |||
| Tough Formula question | Excel Worksheet Functions | |||
| tough lookup question | Excel Discussion (Misc queries) | |||
| A tough macro question | Excel Discussion (Misc queries) | |||
| Tough question | Excel Discussion (Misc queries) | |||
Linear Mode
