summery of several worksheets

  • Thread starter Thread starter Bilal
  • Start date Start date
B

Bilal

Dear support team,

I have a workbook that contains several worksheets, in
these sheets I have a data that I need to transfer to
summery sheet, example:

work sheets, sheet1,sheet2,sheet3,totalsheet,

sheet1 cell A1=100
sheet2 cell A1=200
sheet3 cell A1=300

In the total sheet I need a formula that transfer these
data directly, my exisint formula does not change sheet
number, sheet number is fixed !!

Thanks
 
Bilal

On summary(total) sheet in cell A2 enter........

=INDIRECT("Sheet" & (ROW()-1) & "!A1")

When copied down, the Sheet1 will increment.

Change the ROW()-1 if you start in a different cell.

Gord Dibben Excel MVP
 
Back
Top