I have a communication plan that idetifies the document name, date to send
and if a document must be sent or not. I would like to create a new page that
lists only the document name and send date if the 3rd column = TRUE.

Thanks

Try using, data-filter-auto filter and select the 3rd column dropdown and
filter it to true, this will give you what you ask. If you want it on a
seperate sheet select all of the area you want to copy, Ctl+G choose special
and select the visible cells only box, then copy and paste to the page where
you want them.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"T2Amy" wrote:

I have a communication plan that idetifies the document name, date to send
and if a document must be sent or not. I would like to create a new page that
lists only the document name and send date if the 3rd column = TRUE.

Thanks

Yes - this would work, but I am building more of a wizard, where people
answer questions and then I will display the communication plan. Is there
any way I can get this list to display dynamically? without asking the user
to manipulate it.
The data sheet that is built from my wizard looks like:

doc name send dt true/false
test.doc 11/1/07 true
test2.doc 11/1/07 false

I only want the docs listed as true to display on the list


"T2Amy" wrote:

I have a communication plan that idetifies the document name, date to send
and if a document must be sent or not. I would like to create a new page that
lists only the document name and send date if the 3rd column = TRUE.

Thanks