software

I reckon the answer is going to be Nope, but see if you can prove me wrong…

I wish to be able to reset the Filter Function without the need of having to
click on the filter itself.
I know I’m probably being somewhat too fussy , but the filter is always set
to filter out the same attribute as it’s this that changes (rather then the
need to manually changing on the filter)..

Im sure I have seen a spreadsheet in the past which has a built in Macro
that provides a on page Reset button to reset filters amp; formulas on the
page.. Any Ideas ??

Many thanks,
J.You can add an icon to your favorite toolbar.

Tools|Customize|commands tab|data category.
look for Show All and drag it to a toolbar.

(I've also added the autofilter quot;funnelquot; icon right next to it.)

Monk wrote:
gt;
gt; I reckon the answer is going to be Nope, but see if you can prove me wrong…
gt;
gt; I wish to be able to reset the Filter Function without the need of having to
gt; click on the filter itself.
gt; I know I’m probably being somewhat too fussy , but the filter is always set
gt; to filter out the same attribute as it’s this that changes (rather then the
gt; need to manually changing on the filter)..
gt;
gt; Im sure I have seen a spreadsheet in the past which has a built in Macro
gt; that provides a on page Reset button to reset filters amp; formulas on the
gt; page.. Any Ideas ??
gt;
gt; Many thanks,
gt; J.

--

Dave Peterson

Thanks Dave for the input..

This would be a great idea if I wasn’t so fickle..
I’m really trying to find away of changing the filter results without the
need of clicking on it (Ay.. I hear you say..?)

Basically the filter is set to filter out all rows that represent the number
‘1’ (no other filter result needed)
The cells (B1350) which contain this number ‘1’ are actually a formula and
depending on details specified in a completely separate cell (A1), will
depend if the formula results show the number ‘1‘ or something different (so
ignored by filter).

Currently when cell ‘A1’ changes, the formula/rows all change accordingly,
but the filter results remain the same until you reclick the filter again.

Some form of refresh button would be desirable (maybe not possible).. !
Any ideas..
J.quot;Dave Petersonquot; wrote:

gt; You can add an icon to your favorite toolbar.
gt;
gt; Tools|Customize|commands tab|data category.
gt; look for Show All and drag it to a toolbar.
gt;
gt; (I've also added the autofilter quot;funnelquot; icon right next to it.)
gt;
gt; Monk wrote:
gt; gt;
gt; gt; I reckon the answer is going to be Nope, but see if you can prove me wrong…
gt; gt;
gt; gt; I wish to be able to reset the Filter Function without the need of having to
gt; gt; click on the filter itself.
gt; gt; I know I’m probably being somewhat too fussy , but the filter is always set
gt; gt; to filter out the same attribute as it’s this that changes (rather then the
gt; gt; need to manually changing on the filter)..
gt; gt;
gt; gt; Im sure I have seen a spreadsheet in the past which has a built in Macro
gt; gt; that provides a on page Reset button to reset filters amp; formulas on the
gt; gt; page.. Any Ideas ??
gt; gt;
gt; gt; Many thanks,
gt; gt; J.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

I think you'll have to refilter if the values change.

Monk wrote:
gt;
gt; Thanks Dave for the input..
gt;
gt; This would be a great idea if I wasn’t so fickle..
gt; I’m really trying to find away of changing the filter results without the
gt; need of clicking on it (Ay.. I hear you say..?)
gt;
gt; Basically the filter is set to filter out all rows that represent the number
gt; ‘1’ (no other filter result needed)
gt; The cells (B1350) which contain this number ‘1’ are actually a formula and
gt; depending on details specified in a completely separate cell (A1), will
gt; depend if the formula results show the number ‘1‘ or something different (so
gt; ignored by filter).
gt;
gt; Currently when cell ‘A1’ changes, the formula/rows all change accordingly,
gt; but the filter results remain the same until you reclick the filter again.
gt;
gt; Some form of refresh button would be desirable (maybe not possible).. !
gt; Any ideas..
gt; J.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; You can add an icon to your favorite toolbar.
gt; gt;
gt; gt; Tools|Customize|commands tab|data category.
gt; gt; look for Show All and drag it to a toolbar.
gt; gt;
gt; gt; (I've also added the autofilter quot;funnelquot; icon right next to it.)
gt; gt;
gt; gt; Monk wrote:
gt; gt; gt;
gt; gt; gt; I reckon the answer is going to be Nope, but see if you can prove me wrong…
gt; gt; gt;
gt; gt; gt; I wish to be able to reset the Filter Function without the need of having to
gt; gt; gt; click on the filter itself.
gt; gt; gt; I know I’m probably being somewhat too fussy , but the filter is always set
gt; gt; gt; to filter out the same attribute as it’s this that changes (rather then the
gt; gt; gt; need to manually changing on the filter)..
gt; gt; gt;
gt; gt; gt; Im sure I have seen a spreadsheet in the past which has a built in Macro
gt; gt; gt; that provides a on page Reset button to reset filters amp; formulas on the
gt; gt; gt; page.. Any Ideas ??
gt; gt; gt;
gt; gt; gt; Many thanks,
gt; gt; gt; J.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson