Filter Out Duplicate Info Onto a different Sheet

[davejohnson]

I'm using MS Excel 2000. Is there any way I can use autofilter and data validation list to sort and filter information (from a different sheet from other than orginal) and dynamically update and display it on another?

Scenario: I have three sheets, one called Dashboard, Summary of All, and Output. The Dashboard will be used to sort the information, the Summary of All is where all the info is stored in table, and the Output is where the sorted data will be displayed. However, I only want certain columns to be displayed here.

 

[Datsmart]

I would suggest looking at Advanced Filtering to do what you are after.
Good example of Advanced Filter steps here:
http://www.contextures.com/xladvfilter01.html

AdvancedFilter Demo
http://www.contextures.com/xlVideos04.html

AdvancedFilter will allow you to include only the columns you want to be listed to the output worksheet.

 

[davejohnson]

Thanks Datsmart...That worked beautifully! But now can I filter/update/sort the data copied to the new sheet, based on the critera range? And maybe even taking the critera range to another sheet. I created the critera range using the data validation list. So it is a drop-down

 

[Datsmart]

I am not following what you are asking. Please post and example of your data before and after it is "filter/update/sort"ed.

 

[davejohnson]

I guess what I am really asking is, can I make the extracted data updateable based on the data set it was taken from? Also, I used a drop down for the critera range in Advanced Filter. So now I would like to sort the extracted data based on the drop down. I hope that makes more sense. If not, please feel free to call me in a couple of hours at 586-883-8751