Recent content by holmes123

> A1 in this case would not get changed until user clicks somewhere other than on the scroll bar. I made that change and A1 never changes when the user clicks elsewhere. Nothing happens. I also suspect I left out some important details. The rows that show fruit details (in rngFruits)...

I use an ActiveX Scroll Bar control to allow a user to scroll among 10 rows that show fruits, with 5 rows/fruits showing at a time. When he selects a fruit by clicking in the range, rngFruits, a WorkSheetChange event assigns the row number for the selected fruit to valFruit_Row...

> make a pivot off of data set. I already have three pivot tables based off the data. Currently, the three sections of the dashboard reference the respective rows and columns in the pivot tables. > paste val into dashboard file. Not sure I follow. Paste the pivot table results...

Montrey: I'm not summing anything, so I don't see how the SumIf function would help.

Luke: When I tried the Advanced Filter option, I noticed a few issues. 1. The advanced filter feature does not work if the data range has been converted into a data table. (It always selects only the first row of the range, regardless of what criteria.) This means if you want to use the...

(Using Excel 2007.) I'm looking for advice about the performance (i.e., speed) of using pivot tables vs. data tables (Insert > Table) when you need to pull data from a very large worksheet of 10 columns and 100,000+ records. Is one typically faster than the other? My worksheet looks like...

I'm trying to use a macro to sort numeric values in a pivot table based on a column selected in another sheet. I've managed to capture the column number of the pivot on which the data should be sorted. This is stored in a variable, pivotColToSort. How can I pass the value of this column...