#1
|
|||
|
|||
Link to and display data
Good afternoon I have a file that on tab 1 that has a long list of various data including a column of date created On tab 2 i have layed out some KPI's so that in each month its counts the number of entries that correspond with that month and adds a figure into the cell. What i would like to do is to create a link so if i was to click the number the data would pop up or be shown in another worksheet, is this possible and if so can you explain how to acheive Thanks inadvance |
#2
|
||||
|
||||
Without seeing the workbook, with some sample data, it's impossible to tell you what the best approach might be.
You can attach an Excel file to a post (delete any sensitive data) via the paperclip symbol on the 'Go Advanced' tab.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Match two sets of data and display specific data | lolly150 | Excel | 1 | 05-14-2012 10:33 PM |
Display history for spreadsheet data | cjaye | Excel Programming | 11 | 05-08-2012 04:22 PM |
How to set a no-display value to cells with a no-value link | KIM SOLIS | Excel | 3 | 10-31-2011 11:37 PM |
Link data from embedded excel sheet | rwbarrett | Word | 1 | 05-27-2011 02:05 AM |
Data Set Display Size - PP 2007 | TonyMan | PowerPoint | 1 | 04-14-2010 05:45 AM |