Briefly! Table Tools is a multi-optioned tool that allows far easier filtering of data in a Table. It allows easier manipulation of the results of the filtering.
In Excel 2007-2016 we have an option on the Ribbon on the Insert tab
How do I convert my range to a Table:
If you select a cell in your normal range and press the Table button it will show you this dialog.
After you press the OK button you see a nice looking Table and if you
select a cell in your Table you'll see that there is a new tab named Design
on the Ribbon. You will find a lot of nice options on this tab
But as always I want more options so I created a small add-in that adds a tab next to the Design tab named RDB Tools with a few more options.
1) Turn AutoFilter On or Off
2) Clear Filter of the ActiveCell's column
3) Special Filter options : Filter on selected Cell value, Color, Font color or Icon
4) Special Sort Options : Put selected Cell Color, Font Color or Icon on top and Custom Sort
5) Copy Visible data to a new worksheet
6) Copy visible data to a new workbook
7) Delete visible data
8) Print Table
9) Split data of every unique value in a column to a new worksheet of the same workbook
10) Split data of every unique value in a column to a new worksheet in a new workbook
11) Split data of every unique value in a column to a new workbook in a new folder
This option creates a worksheet with hyperlinks to the workbooks so you can open them easy
12) Add a button that open a Userform with a lot of Date
Date to Date
13) Add error checking for the 8192 areas limit
in Excel in the copy and delete options and add a option to insert a Sort
column named "RDB Sort Column" with numbers 1, 2, 3, .............
When you hit the 8192 areas limit you can do this:
1: Insert the Sort column named "RDB Sort Column"
2: Sort the column that you want to filter (less areas if you do this)
3: Filter this column the way you want
4: Use a Copy or Delete option in the add-in
5: Sort the "RDB Sort Column" to get back the correct order of the records
6: Delete the "RDB Sort Column" column
14) Add a button to delete the the Table column of the activecell
Easy if you want to delete the "RDB Sort Column" for example.
You can download it here together with a small test workbook
If you have suggestions or find bugs please let me know.
Version 1.12, 19-Jan-2009
If you want VBA code examples visit this page