|
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? |
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? |
| All times are GMT +1. The time now is 05:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com