I'm looking for some code to filter a list based on a calculated value. I
have a table of data like this.

Date Count
3/01/09 2
3/02/09 3
3/03/09 6
etc...

I have a userform that the user selects a calendar week (excel function
weeknum). Is there a way to filter this data using the excel function weeknum?

Thanks

It's late in the eastern US now, but even if it wasn't I don't think I
understand what you want here. Could you add some more details? Before and
after? What sheet/cell does the UserForm link to? For instance, what do you
expect to see after the code fires?

Thanks,
Ryan--

--
RyGuy


"Brad" wrote:

I'm looking for some code to filter a list based on a calculated value. I
have a table of data like this.

Date Count
3/01/09 2
3/02/09 3
3/03/09 6
etc...

I have a userform that the user selects a calendar week (excel function
weeknum). Is there a way to filter this data using the excel function weeknum?

Thanks

The userform links to a table of data in excel on sheet1. I want the user to
be able to filter the list by the date column, but instead of using the date
it filters based on weeknum(date) so if the user selects calendar week 10,
then this list would only show 3/1/09 - 3/7/09.

Hope that explains better

"ryguy7272" wrote:

It's late in the eastern US now, but even if it wasn't I don't think I
understand what you want here. Could you add some more details? Before and
after? What sheet/cell does the UserForm link to? For instance, what do you
expect to see after the code fires?

Thanks,
Ryan--

--
RyGuy


"Brad" wrote:

I'm looking for some code to filter a list based on a calculated value. I
have a table of data like this.

Date Count
3/01/09 2
3/02/09 3
3/03/09 6
etc...

I have a userform that the user selects a calendar week (excel function
weeknum). Is there a way to filter this data using the excel function weeknum?

Thanks

Hummmm, I don't think I've ever dealt with this, so I'm exactly sure how to
dandle it, but perhaps you can find a solutions from one of these links:
http://www.contextures.com/xladvfilter01.html
http://www.contextures.com/xlautofilter03.html

HTH,
Ryan---


--
RyGuy


"Brad" wrote:

The userform links to a table of data in excel on sheet1. I want the user to
be able to filter the list by the date column, but instead of using the date
it filters based on weeknum(date) so if the user selects calendar week 10,
then this list would only show 3/1/09 - 3/7/09.

Hope that explains better

"ryguy7272" wrote:

It's late in the eastern US now, but even if it wasn't I don't think I
understand what you want here. Could you add some more details? Before and
after? What sheet/cell does the UserForm link to? For instance, what do you
expect to see after the code fires?

Thanks,
Ryan--

--
RyGuy


"Brad" wrote:

I'm looking for some code to filter a list based on a calculated value. I
have a table of data like this.

Date Count
3/01/09 2
3/02/09 3
3/03/09 6
etc...

I have a userform that the user selects a calendar week (excel function
weeknum). Is there a way to filter this data using the excel function weeknum?

Thanks