share/ link info between sheets
 

I have created formulas is sheet 1. I want to create a table in sheet 2 using
totals from sheet 1. How do I work with formulas between sheets?

share/ link info between sheets
 

Say we have a table in Sheet1 from A1 thru D10. In Sheet2 we want the sum of
the first column in Sheet1. Use:

=SUM(Sheet1!A1:A10)

--
Gary''s Student - gsnu200742


"thapelo1" wrote:

I have created formulas is sheet 1. I want to create a table in sheet 2 using
totals from sheet 1. How do I work with formulas between sheets?

share/ link info between sheets
 

Thx Gary it worked like a charm!!

Regards
Thapelo


Gary''s Student wrote:
Say we have a table in Sheet1 from A1 thru D10. In Sheet2 we want the sum of
the first column in Sheet1. Use:

=SUM(Sheet1!A1:A10)

I have created formulas is sheet 1. I want to create a table in sheet 2 using
totals from sheet 1. How do I work with formulas between sheets?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200709/1