Have you tried the macro recorder while you go through the steps?

"I have to sort on the "checked out date" then cut and
past that into a new document"


Gord Dibben MS Excel MVP

On Wed, 30 Sep 2009 13:07:02 -0700, AVCM
wrote:

I manage a library of a couple thousand documents. I check these out to
people daily. I would like to have a report that shows which documents have
been checked out more then 30 days. Right now I have a column that shows the
date checked out. In the next column I use this formula,
=IF(P2<=TODAY()-30,"DUE","") this works fine to tell me when its due, but to
get a report out of it I have to sort on the "checked out date" then cut and
past that into a new document. Can someone show me how to come up with and
report that would give me this information at the press of a button, or two?
Thank you.