Might be asking too much

I am using excel to track day to day project hours on a bi-weekly interval.
In the cell where I am entering my time I am also adding comments as to what
work was done during that time. What I would like to do is figure out a way
that I can extract the comments out to print. Now I know that I can print
them at the end of the layout which is essentially what I want, but the way
it defaults the printing is by calling out the cell name i.e. (c24) then the
comment. The problem is that I have no way of know which cell that is. so
what I would like to do is basically set up a layout myself that would
adjust everything the way I would like to see it, and the way I would like
to see it is to have the project name, date, hours worked, and comment in a
row. Is this a feasible request or am I starting to leave the jurisdiction
of excel. I know that I can get software that does exactly what I am
wanting, but if there is a way to do this without buying additional stuff
then that would be great. Thanks for the help

HT

HT,
IMHO, if you go to www.openoffice.org, then you will find what you need. The
Open Office suite includes a database (have't used it yet myself), and its
free.

Beege


"HT" <[email protected]> wrote in message
news:[email protected]...
>I am using excel to track day to day project hours on a bi-weekly interval.
>In the cell where I am entering my time I am also adding comments as to
>what work was done during that time. What I would like to do is figure out
>a way that I can extract the comments out to print. Now I know that I can
>print them at the end of the layout which is essentially what I want, but
>the way it defaults the printing is by calling out the cell name i.e. (c24)
>then the comment. The problem is that I have no way of know which cell
>that is. so what I would like to do is basically set up a layout myself
>that would adjust everything the way I would like to see it, and the way I
>would like to see it is to have the project name, date, hours worked, and
>comment in a row. Is this a feasible request or am I starting to leave the
>jurisdiction of excel. I know that I can get software that does exactly
>what I am wanting, but if there is a way to do this without buying
>additional stuff then that would be great. Thanks for the help
>
> HT
>

This should find your comments addresses

Sub findcomments()
Set mycomments = Cells.SpecialCells(xlCellTypeComments)
for Each c In myComments
msgbox c.Address
Next
End Sub


--
Don Guillett
SalesAid Software
[email protected]
"HT" <[email protected]> wrote in message
news:[email protected]...
>I am using excel to track day to day project hours on a bi-weekly interval.
>In the cell where I am entering my time I am also adding comments as to
>what work was done during that time. What I would like to do is figure out
>a way that I can extract the comments out to print. Now I know that I can
>print them at the end of the layout which is essentially what I want, but
>the way it defaults the printing is by calling out the cell name i.e. (c24)
>then the comment. The problem is that I have no way of know which cell
>that is. so what I would like to do is basically set up a layout myself
>that would adjust everything the way I would like to see it, and the way I
>would like to see it is to have the project name, date, hours worked, and
>comment in a row. Is this a feasible request or am I starting to leave the
>jurisdiction of excel. I know that I can get software that does exactly
>what I am wanting, but if there is a way to do this without buying
>additional stuff then that would be great. Thanks for the help
>
> HT
>