Link to last used cell
 

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.

Link to last used cell
 

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

=LOOKUP(2,1/($B$1:$B$655350),$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
--
Gary''s Student - gsnu200757


"Mike Armstrong" wrote:

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.

Link to last used cell
 

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?

"Gary''s Student" wrote:

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

=LOOKUP(2,1/($B$1:$B$655350),$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
--
Gary''s Student - gsnu200757


"Mike Armstrong" wrote:

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.

Link to last used cell
 

Yes... check back tomorrow (I need a computer with more than email)
--
Gary''s Student - gsnu200757


"Mike Armstrong" wrote:

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?

"Gary''s Student" wrote:

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

=LOOKUP(2,1/($B$1:$B$655350),$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
--
Gary''s Student - gsnu200757


"Mike Armstrong" wrote:

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.

Link to last used cell
 

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

"Gary''s Student" wrote:

Yes... check back tomorrow (I need a computer with more than email)
--
Gary''s Student - gsnu200757


"Mike Armstrong" wrote:

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?

"Gary''s Student" wrote:

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

=LOOKUP(2,1/($B$1:$B$655350),$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
--
Gary''s Student - gsnu200757


"Mike Armstrong" wrote:

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.