Filter a List

B

Brad

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
 
R

ryguy7272

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--
 
B

Brad

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top