| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link Access DB to excel WS to share certain data, not whole DB, ho | Excel Discussion (Misc queries) | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
| How to share info from one file to another? | Excel Discussion (Misc queries) | |||
| How do I effeciently share text from two different sheets? | Excel Worksheet Functions | |||
| How can I share information between sheets in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
