How can I build a custom list in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top