Excel 2003 Sum question

[KeithSimon]

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

 

[Mike H]

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

 

[RagDyer]

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.