A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how to set a button to filter a table



 
 
Thread Tools Display Modes
  #1  
Old February 18th, 2009, 10:29 PM posted to microsoft.public.excel.charting
[email protected]
external usenet poster
 
Posts: 1
Default how to set a button to filter a table

I have a spreadsheet with 2 tabs. "Instr" and "BF_List". On the
Instr tab, I have a table to generate the 12 months of the year with
from and to dates based on cell T69. This way I can have dates for
years 2009 to 2020. The table has the dates in cells T71 (ie. Jan. 1,
2009) and cell U71 has Jan. 31, 2009. Down the table to Dec.

Now on the tab BF list, starting on row 4 I have effective date, name
and other details up to column F. This list could have assorted
dates from Jan. 1, 2009 to Dec. 31, 2009. I want to be able to give
the users an easy option to sort by month. So, I had thought adding a
button for each month. ie. sort Jan. sort Feb. and so on.

My problem is the code for the macro to sort. I need to be able to
pull from the first tab on the Instr. sheet the from and to dates so
that I can filter the list. I have chosen 'equal to or greater than"
and cell T71 for Jan. 1, 2009 and then then end date of 'less than or
equal to" cell U71.

I would change cells for each month.

I have not found a way to get the macro code to select from the table
on the other tab.

The table I want to sort has a header row A3 to F3 and the data is
from A4 to F4 down to row 4000.

this is what I have so far.

Range("A4").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:="=01-Jan-2009",
Operator:= _
xlAnd, Criteria2:="=31-jan-2009"
End Sub


thanks for any help or options.

Mel
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.