Excel 2007: If a user clicks in Cell 'B4' or... 'E12' in a worksheet, is
there a function or VBA code stub where I can learn what cell they clicked?
Row is needed, row and column is preferred.

I am trying to do a table of DSUM results from a dynamically-updating
database with... 3500 rows or so. I've built a pivot table aggregating the
results of the transactions. Each pivot table row represents a Call Center
Agent and total transactions. I want to extend each row to include
transactions within a specific hour - e.g. Column D=11:00, E=12:00, F=13:00,
etc. I can query the database table to return transactions per a specific
agent for a specific hour

I have the data table and the pivot table of total transactions per agent
working. I do not want to build the table of 55 agents x 24 hours (implying
55 x 24 x 2 criteria), as the agents change day-to-day and hour-to-hour based
on shift. My vision is for the user to click on an agent name, and the
spreadsheet updates the transactions per hour graph of the agent selected.

If I know which cell a user chooses, I only need to build 24 x 2 criteria
for 24 DSUM updates.

Any thoughts?

--Dan