How do I link information in the LAST ROW of a workbook to another??

[Stemage]

Hi all! I'm new here, so if by posting this message directly, I'm not
following procedure, appologies ahead of time.

I'm trying to link information from one workbook to another.

It's for inventory. We have a different page for each item number, and
every time the item is adjusted, it adds a new row to the speadsheet.
I want to be able to list ALL the totals from the different pages into
a new file, so people can see totals by looking at ONE sheet. The
problem is, the row number of the cell I need changes everytime the
source file is edited.

There doesn't appear to be a formula that says something like, -Returns
a value or reference of the last cell in a particular column-

Is this possible?? Thanks!!

- Grant Henry

 

[Paul B]

Stemage, this will return the last numeric valve in sheet 1, column B, will
that help?

=INDEX(Sheet1!B:B,MATCH(9.99999999999999E+307,Sheet1!B:B))


--
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 2000 & 97
** remove news from my email address to reply by email **

 

[Stemage]

Thanks for the help Paul!!

It worked wonderfully!!