Clicking on a cell to generate an action?

[chuckles1066]

Is it possible?

My scenario: I produce a weekly report broken down by day and by sales rep.

Sales reps in column A, days going across from column B.

Each day will show a % of leads converted.....so for example row 2 might contain Joe Bloggs followed by 58%, 43%, 67%, 9%, 22%.

The data that drives this is stored in a worksheet called "data".

Is it possible to click on, say, 9% in the above example and something fires up to show that day's activity for Joe Bloggs from the "data" worksheet?

I've told the powers-that-be the answer is almost certainly no but you guys have amazed me before and so hopefully can do so again.

TIA.

 

[Smitty]

Sure, check out the BeforeDoubleClick event:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

You could probably trigger the Data sheet to AutoFilter from there to display just that information.

HTH,