I have this big spreadsheet. It is basically a list of documents that comes from a Sharepoint site dataview. The data is copied and pasted into Excel 2003. There is a column for the filename, and several text columns that help define the document.
I asked here http://chandoo.org/forums/topic/counting-items-in-column-a-based-on-partial-strings on how to count certain documents based on the criteria in different columns. So my question now becomes, can I generate a sub list of documents on a new sheet based on that chosen criteria?
Thanks.
I asked here http://chandoo.org/forums/topic/counting-items-in-column-a-based-on-partial-strings on how to count certain documents based on the criteria in different columns. So my question now becomes, can I generate a sub list of documents on a new sheet based on that chosen criteria?
Thanks.