Hi gurus! I am working with Excel 2010. I have a spreadsheet with around 40k rows, and maybe 50 columns. The first 8 columns contain my 'raw' data (extracted from another source and cut/paste into Excel). The remainder of the columns are derived data dependant upon the values (or combinations of values) in the first 8 columns. All this data is in a single worksheet. Additional worksheets contain control data (which influences the derived columns in the data worksheet via vlookup, etc), summary data (extracted from the data worksheet via countif, etc) and graphs based on the summary data. What I would like to do is to filter the data in the main worksheet so that I can select on certain values in the 8 columns of raw data, and then have the summary/graphs reflect only the 5000 rows (or whatever) of filtered data. The filtering of course if easy, but as the 40k rows are really still there in the data worksheet (just hidden by the filter) I can't get the summary/graphs to work only on the filtered data. Is this possible? It seems like it should be. I'm fairly new to Excel 2010, so is there something I'm missing here? Thanks in advance!