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

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]