Link to last used cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Armstrong - 19 Nov 2007 19:43 GMT

I am creating a dashboard and I want a link on the main dashboard to go to a
cell on a specific sheet in a different workbook. That's no problem...The
issue is that I want this link to show the value of the last used cell in a
column..Example: I have a column for how many calls taken each day at our
help desk. Today, I type the total number of calls into cell B76 of the
master spreadsheet. This is the number that I want to show up on Cell A2 of
my dashboard. Tomorrow, I type the total number of calls into cell B77. This
is now the number that i want to show up on cell A2 of my dashboard. Make
sense? Any help would be appreciated.

Reply to this Message

Gary''s Student - 19 Nov 2007 19:54 GMT

In an un-used cell, say Z100, enter:

=LOOKUP(2,1/($B$1:$B$65535>0),$B$1:$B$65535)

This will be the value in the last used cell in column B. Have your
dashboard point to Z100 in the master

Signature

Gary''s Student - gsnu200757

> I am creating a dashboard and I want a link on the main dashboard to go to a
> cell on a specific sheet in a different workbook. That's no problem...The
[quoted text clipped - 5 lines]
> is now the number that i want to show up on cell A2 of my dashboard. Make
> sense? Any help would be appreciated.

Reply to this Message

Mike Armstrong - 19 Nov 2007 20:12 GMT

That works great, and I will use it! Anyway of hyperlinking to it as well.
In other words, another cell on the dashboard that I can click on to take me
to that cell(The one referenced by the formula, not where the formula is) in
the master?

> In an un-used cell, say Z100, enter:
>
[quoted text clipped - 12 lines]
> > is now the number that i want to show up on cell A2 of my dashboard. Make
> > sense? Any help would be appreciated.

Reply to this Message

Gary''s Student - 19 Nov 2007 20:54 GMT

Yes... check back tomorrow (I need a computer with more than email)

Signature

Gary''s Student - gsnu200757

> That works great, and I will use it! Anyway of hyperlinking to it as well.
> In other words, another cell on the dashboard that I can click on to take me
[quoted text clipped - 17 lines]
> > > is now the number that i want to show up on cell A2 of my dashboard. Make
> > > sense? Any help would be appreciated.

Reply to this Message

Mike Armstrong - 26 Nov 2007 15:13 GMT

Any help on this? Need to now link to the latest cell.

> Yes... check back tomorrow (I need a computer with more than email)
>
[quoted text clipped - 19 lines]
> > > > is now the number that i want to show up on cell A2 of my dashboard. Make
> > > > sense? Any help would be appreciated.

Reply to this Message