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
|