LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 31
Default Excel cell to display summary of columns

I have a Excel sheet that has 71 rows and 140 columns. In the colums are
training courses the employees have taken and in the rows are my employees. I
want to be able to click on the cell that has an employees name and a window
to pop up with the summary of the courses they have taken.....like the
comment box. I do not want to make a comment and have to edit each comment
when an employee completes a training course. I want the cell pop up window
with the employees name to automatically know and list the courses taken, to
pull it from the spreadsheet.
Any ideas? I am not sure if this is even possible.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot table to display the value instead of a summary Jinghui Excel Discussion (Misc queries) 1 May 8th 08 02:42 AM
Display a weekly summary markag Excel Worksheet Functions 3 July 31st 06 09:24 PM
selecting different cell ranges across sheets, to display on summary page NetMax Excel Discussion (Misc queries) 4 January 17th 06 07:42 PM
How do I display data from multiple worksheets in a summary sheet. stardust Excel Discussion (Misc queries) 1 March 18th 05 12:26 PM
Display summary sheet with Now or Today data. Wayne New Users to Excel 5 December 29th 04 08:45 AM


All times are GMT +1. The time now is 03:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"