Help pulling info from other sheeting withing a workbook.

  • Thread starter Thread starter Plasma
  • Start date Start date
P

Plasma

okay, i have 1 workbook with 4 sheets. Sheets names are say, sheet1
sheet2, sheet3 and sheet4.

on sheet4, i want to create a formula that will pull rows B2 to H2
from sheet1, B2 to H2 on sheet2 and B2 to H2 from sheet3 (it will be
STDEV formula)



i've come up with:


Code
-------------------
=STDEV('sheet1'!B2:H2
-------------------


which will pull the info from sheet1, but i can't figure out how to ad
in the data from the other 2 sheets. is it possible? if so, how?

any help would be greatly appreciate
 
Back
Top