Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
Using paste link infromation in cell to hyperlink to source cell? | Excel Worksheet Functions |