hi, !

I am struggling trying to create a pivot table from filtered data.
I am enclosing the sub but am scared to death to do it because I now it is not pristine code.
I believe the problem is that I successfully filter the data but then I select all of the rows for the pivot table
rather than just the filtered rows. Any help is appreciated...

it is not so pristine either, but you might want to give a try to the following (for an existing PT):

- add a column to your source range using something like: =subtotal(2,e2)
put some title such as "visible" -???-

- use the PT-Wizard, backward to include the above (new) column as a page-field (and finish the PTW)

- now, after filtering, you can "play" by refreshing your PT and/or "filtering" over the (new) page-field

hth,
hector.