Hello Experts,
I have today 2 sheets - and I would like to create the following:

When the focus is on one cell in sheet 1 - I would like to have a button
which the user can click (a macro behind)to insert that value into a pivot
filter on sheet 2 - and then refresh the pivottable on sheet 2 based on the
new filter

How can I do that....?

Any help is appriciated
Thanks
Henrik