Might be asking too much

[HT]

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

 

[Beege]

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

 

[Don Guillett]

This should find your comments addresses

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