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.