Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Sum question
Hi Everyone,
I have a quesiton, I'm hoping to get some help on. Thanks in Advance! I have a worksheet with monthly totals and a seperate worksheet with YTD in the same spreadsheet file. How do I get the totals from one of the columns in my monthly over to a cell in my YTD spreadsheet dynamically? Meaning as the totals for the month change, it automatically changes over on the referenced YTD cell? I hope I was able to articulate this correctly. Thanks, Keith |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Sum question
Hi,
To get the last filled numeric cell in a column use =LOOKUP(6.022*10^23,Sheet1!A:A) Which returns the last used cell in column A on sheet 1 Mike "KeithSimon" wrote: Hi Everyone, I have a quesiton, I'm hoping to get some help on. Thanks in Advance! I have a worksheet with monthly totals and a seperate worksheet with YTD in the same spreadsheet file. How do I get the totals from one of the columns in my monthly over to a cell in my YTD spreadsheet dynamically? Meaning as the totals for the month change, it automatically changes over on the referenced YTD cell? I hope I was able to articulate this correctly. Thanks, Keith |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Sum question
You can link the cells of the two WBs.
This procedure will make XL create the path for you. First of all, open both WBs. In the YTD WB, click in the cell that you wish to display the monthly total. Type in an equal (=) sign - *DON'T* hit <Enter, navigate to the monthly WB and click in the cell containing the total, NOW hit <Enter. This creates a link between both cells, displaying the updated contents of the monthly WB cell. Click in the YTD cell, and you'll see the formula XL created for you. Now, close the monthly WB and you'll see the formula in the YTD cell increase as it now contains the full path to the monthly cell. You can use that first YTD formula XL made for you as a syntax guide, so that you can write the linking formulas yourself, if you wish. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "KeithSimon" wrote in message ... Hi Everyone, I have a quesiton, I'm hoping to get some help on. Thanks in Advance! I have a worksheet with monthly totals and a seperate worksheet with YTD in the same spreadsheet file. How do I get the totals from one of the columns in my monthly over to a cell in my YTD spreadsheet dynamically? Meaning as the totals for the month change, it automatically changes over on the referenced YTD cell? I hope I was able to articulate this correctly. Thanks, Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Question | Excel Discussion (Misc queries) | |||
Question on XML in Excel 2003 | Excel Discussion (Misc queries) | |||
Question for MVP - install Excel 2003 on MS Server 2003 | Setting up and Configuration of Excel | |||
Excel 2003 Question | Excel Discussion (Misc queries) | |||
excel 2003 question | Excel Worksheet Functions |