Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Creating reports based on data in a cell

I am creating an electronic Earned Leave report for the employees of my
company. I would like to be able to click on a cell -- in this instance,
vacation leave -- and get additional information.

For example:

Let's say I requested vacation leave on 1/5/07, 3/4/07 and 5/30/07. The
cell states I have taken 3 days (or 24 hours) worth of vacation.

But then I forgot which days I had taken vacation. I would like to be able
to click on the cell that states 24 hours and see a brief report that
identifies every time I made an entry to that cell. The report would tell me
that I had taken the aforementioned 3 days.

Is something like this possible or am I asking for a miracle?!!! Thank you.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default Creating reports based on data in a cell

You could create a "Comment" in a cell

Insert Comment


"LoriKLynn" wrote:

I am creating an electronic Earned Leave report for the employees of my
company. I would like to be able to click on a cell -- in this instance,
vacation leave -- and get additional information.

For example:

Let's say I requested vacation leave on 1/5/07, 3/4/07 and 5/30/07. The
cell states I have taken 3 days (or 24 hours) worth of vacation.

But then I forgot which days I had taken vacation. I would like to be able
to click on the cell that states 24 hours and see a brief report that
identifies every time I made an entry to that cell. The report would tell me
that I had taken the aforementioned 3 days.

Is something like this possible or am I asking for a miracle?!!! Thank you.

Reply
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
Creating a Data Validation List based on a Value in another cell LondonLion Excel Worksheet Functions 2 June 8th 07 12:23 AM
Creating Reports from Excel data to Word Gaz Excel Discussion (Misc queries) 1 November 26th 06 06:38 PM
Creating reports that grow/shrink dsanita Excel Discussion (Misc queries) 0 July 25th 06 10:00 PM
How to create reports based on data residing in multiple workbooks Almi Excel Discussion (Misc queries) 1 May 12th 06 04:42 PM
Creating Customize Reports RickGreg Excel Discussion (Misc queries) 4 February 1st 05 10:27 PM


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

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

About Us

"It's about Microsoft Excel"