Macro Button Filter

**butthefuko** · 11-02-2011, 06:29 PM

Hi All

I'm looking for some help?

Attached is an example of a projects issues log with a load of data in columns.

you will see at the top column B, that I have pre defined critera i.e. pre-install, post-install and post commissioning.

I want to create individual macro buttons (pre-install, post-install and post commissioning) that when pressed will only sorts by those individual criteria's.

Please ask questions

All the help would be much appreciated.

Many Thanks

**arlu1201** · 11-03-2011, 03:07 AM

You said you want to sort based on the criteria - post commissioning, Post-install, etc? But this cannot be done in the same sheet since the data is in 1 column. What are you trying to achieve through this? Do you want only those criteria cells to be visible when clicked?

You also have some macro requirement in rows 2 and 3? What is that about?

**royUK** · 11-03-2011, 03:12 AM

The best way to start would be to use the Macro Recorder to get the basic code. The Macro Recorder is in the Developer tab of the Excel 2007 & 2010.This will need editing so you can post back with the code for further help.

Note your profile says that you are using Excel 2003, your example is from the newer Excel versions so you need to amend your profile

**butthefuko** · 11-03-2011, 06:02 AM

Originally Posted by arlu1201

You said you want to sort based on the criteria - post commissioning, Post-install, etc? But this cannot be done in the same sheet since the data is in 1 column. What are you trying to achieve through this? Do you want only those criteria cells to be visible when clicked?

You also have some macro requirement in rows 2 and 3? What is that about?

Ok apologies for not being clear

I want to essentially automate the spreadsheet. I have limited knowledge of excel VBA/macros.

For example
If I had a automated sort button, so when I clicked on let say post install the spreadsheet would automatically show all the rows that are associated with "post-install"

This can be manually done by the filter feature in excel, but as more and more data gets entered the manual way becomes time consuming. hence automating with buttons at the top of the worksheet.

Hope this makes more sense.

Thanks

**arlu1201** · 11-05-2011, 05:47 AM

I have inserted 3 buttons in place of your text fields in column B (as i couldn't assign macros to them). See if this is what you need.

**butthefuko** · 11-06-2011, 03:37 PM

Originally Posted by arlu1201

I have inserted 3 buttons in place of your text fields in column B (as i couldn't assign macros to them). See if this is what you need.

arlu1201

You absolute legend!. the text fields were just there for my mental note.

I will have a play with my other text fields to see if I can get those to sort as well.

Once again you are a life saver.

if you are ever in reading let me know I buy you a couple of pints.

cheers