Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
not sure how to create this function
First off I am using Excel 2003
I have a workbook set up to cover my financial assets. My first worksheet (Sheet1) is the main one which has all my data on it. The other worksheets are where I have the detailed information to get certain figures - for example, Sheet7. On these worksheets, I have a cell (cell F20) with a function to add up all figures in a column for a total. I want to refer to this formula in the cell on Sheet7 in my main worksheet (Sheet1) with all my totals. However, I can't figure it out to get this to work. I want to be able to add more data to Sheet7, thus changing the total in cell F20 - and this change is automatically reflected when I switch back to Sheet1. Is this possible? if so, how do I create the function? Thanks for your help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
not sure how to create this function
In your main sheet you would have a formula like this:
=Sheet7!F20 Hope this helps. Pete On Mar 8, 4:58*pm, dilbert16588 wrote: First off I am using Excel 2003 I have a workbook set up to cover my financial assets. My first worksheet (Sheet1) is the main one which has all my data on it. The other worksheets are where I have the detailed information to get certain figures - for example, Sheet7. On these worksheets, I have a cell (cell F20) with a function to add up all figures in a column for a total. I want to refer to this formula in the cell on Sheet7 in my main worksheet (Sheet1) with all my totals. However, I can't figure it out to get this to work. I want to be able to add more data to Sheet7, thus changing the total in cell F20 - and this change is automatically reflected when I switch back to Sheet1. Is this possible? if so, how do I create the function? Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create function | Excel Worksheet Functions | |||
How to create a function | Excel Worksheet Functions | |||
Trying to create a certain function | Excel Worksheet Functions | |||
Create new function | Excel Discussion (Misc queries) | |||
create function | Excel Worksheet Functions |