| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sending information from one worksheet to another
I am currently making a Finanical Budget and Spending work sheets. How do I
set it up where the data in a cell showing total from a column, in the first worksheet, will automatically go to a cell the 2nd one? Thanks -- Kevin Hicks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sending information from one worksheet to another
Kevin, something like this, =Sheet1!A1
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Kevin" wrote in message ... I am currently making a Finanical Budget and Spending work sheets. How do I set it up where the data in a cell showing total from a column, in the first worksheet, will automatically go to a cell the 2nd one? Thanks -- Kevin Hicks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sending information from one worksheet to another
Paul,
It didn't work. Can you be more specific and/or tell me what it is called what i am doing? thanks for your help -- Kevin Hicks "Paul B" wrote: Kevin, something like this, =Sheet1!A1 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Kevin" wrote in message ... I am currently making a Finanical Budget and Spending work sheets. How do I set it up where the data in a cell showing total from a column, in the first worksheet, will automatically go to a cell the 2nd one? Thanks -- Kevin Hicks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sending information from one worksheet to another
Kevin, if you put =Sheet1!A1 in another sheet, say sheet2 cell B1 it will
show what is in sheet1 cell A1, if this is not what you need please be more specific so we might have a better understanding of what you want to do. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Kevin" wrote in message ... Paul, It didn't work. Can you be more specific and/or tell me what it is called what i am doing? thanks for your help -- Kevin Hicks "Paul B" wrote: Kevin, something like this, =Sheet1!A1 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Kevin" wrote in message ... I am currently making a Finanical Budget and Spending work sheets. How do I set it up where the data in a cell showing total from a column, in the first worksheet, will automatically go to a cell the 2nd one? Thanks -- Kevin Hicks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calling up information from a different worksheet. | Excel Worksheet Functions | |||
| how can I group information from more than one worksheet | Excel Worksheet Functions | |||
| How do i add to information to microsoft exel worksheet | Excel Worksheet Functions | |||
| Extract information from worksheet | Excel Discussion (Misc queries) | |||
| Can I sync information on one worksheet with another worksheet | Excel Worksheet Functions | |||
Linear Mode
