View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Josh Craig Josh Craig is offline
external usenet poster
 
Posts: 40
Default 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?