Hello,
I have the following sheet:
AjlJtrt.png
I'm looking to have the button to filter so that only "long term isolations" are shows.
Only rows with a value/date in column K.
And when click again, the filter is reset.
I have no experience or knowledge in using ActiveX or macros.
So I hope that maybe someone here can help med out?
Cheers,
John
Hi Storic,
Welcome to the Forum!
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thanx for your reply.
Have made an example workbook with 2 sheets. Where sheet number 2 shows how I want the filter to work when I press the button.
When I press the button once more, I would like to reset the filters so that everything is shown.
Have searched online, but have not been able to get anything to work.
I don't know if this script is something that is usable? With some modification off course.
And it has to work in a table, since there will be more rows added as we go.
Hope someone understands what I'm aiming for and are able to help me.
Please Login or Register to view this content.
Cheers,
Try this:
Please Login or Register to view this content.
Thanx again,
I'm not exactly sure how/where to put this to get it to work?
Capture.JPG
Press ALT F11. DoubleClick on Sheet3(Button pressed example)
Paste code in right hand window.
Please Login or Register to view this content.
Last edited by bakerman2; 06-12-2016 at 03:30 AM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thanx a lot!Originally Posted by bakerman2
Press ALT F11. DoubleClick on Sheet3(Button pressed example)
Paste code in right hand window.
Please Login or Register to view this content.
That does exactly what I wanted! =)
Thanks for the rep.
Credit of course goes to Orrin for original code which I just had to put in the right context.
Sorry that I didn't explain it more - here's how I would do it:
Thanks to Bakerman2 for finishing for mePlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks