Hi,

I'm fairlynew to creating office spreadsheets, but can usually get by with google and looking at example templates.

However I can't find the answer to the following question (probably because I am not phrasing g it correctly).

I am need to filter my table by week date (eg show all rows for w/c 22 march.

I have achieved this by using data validation, drop down list option to a pre populated list of dates on the reference shhet. This works fine. The list is 52 rows long (each week of the year).

Is there a way of only showing the weeks greater than today in the drop down list? Weeks gone by will never be used.

I can use the conditional data by directly referencing date list and by usinf the named range method. Can't write vb though.

Can anyone help?