I have a list of dates associated with Week Nbrs starting in column B, C & D.
Several formulas link to a summary table on another worksheet which counts
occurances for a particular week and several years. I have figured out how to
write an If statement using data validation so that the user can see a list
of dates associated with the weekly summary labeled "Week 1" but it requires
me to define names for each week. Example Name: Week_1_2009 = $B$4:$B$7 ect...
This list, below, goes on until the end of 2012.

I was hoping to be able to write a macro that will define all these names for
me without having to physically define each name....I don't know how to do
that....Can anyone help?

Calendar Date Year Week Nbr
1/1/2009 2009 1
1/2/2009 2009 1
1/3/2009 2009 1
1/4/2009 2009 1
1/5/2009 2009 2
1/6/2009 2009 2
1

--
Message posted via http://www.officekb.com