Tough question moving data (may require macro?)

  • Thread starter Thread starter Josh Craig
  • Start date Start date
J

Josh Craig

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?
 
This question comes up every once in a while.
=SUM(Sheet1:Sheet3!C1:C45)

HTH,
Ryan---
 
Back
Top