Hi
I am trying to insert a certain range of cells into a drop down list depending on the value of a certail cell.
it is basically if a cell (G2) = "January" then I want it to display the January Week numbers in a drop down box which I have named 'Januaryweek'
I type the formula in Data validation - =IF(G2="January",Januaryweek,IF(G2="February",Februaryweek, etc etc etc...........but I cant fit it all in for all 12 months?
is there something I am doing wrong??! or will I have to split it into 4 month periods say and just type different formuas into the different sheets for each month for instance??
hope this makes sense!
Many thanks in advance
Bookmarks