button to filter rows

[ea223]

Hi, I am trying to create a spreadsheet where there is a table of information and two buttons above, one that says 'show resolved' and one that says show 'ongoing' and when you click one it filters out all the rows in the table that say either resolved or ongoing depending on which button you clicked. I would also like a 'show all button' which shows everything.
Is anyone able to help me? I am so new to VBA that when I google it I just get nowhere!
Thanks

[Abhi1687]

for "show resolved" use below code:

Please Login or Register  to view this content.

for "show ongoing" use below code:

Please Login or Register  to view this content.

for show all use below code:

Please Login or Register  to view this content.

[ea223]

Wow thank you...would you mind explaining how I input these codes?

[Abhi1687]

if you want to use 3 buttons insert 3 modules and copy paste these codes one in each of them. then to add buttons on the sheet where your data is, add 3 buttons using insert shape then right click on them and click on asign macro and select appropriate macro. i hope that helps

[ea223]

Hmm it doesn't like it for some reason. It says autofilter method of range class failed?!
Thanks for helping me

[Abhi1687]

if you can attach your worksheet i would be able to better identify problem

[ea223]

Ok I will do this as soon as I find a computer that will actually log into this site! Having troubles and using my phone. May be a day or so.
Thank you!

[ea223]

Hi there, sorry for the delay. the computer i usually use cannot log into this site. i have attached my workbook and as you can see when i click the buttons i get an error message. any help would be greatly appreciated.
thank you

[Abhi1687]

Hi
your header range in sheet was different from the code. i have changed it to current range try now

[ea223]

brilliant thank you so much