Totalling of selected months

I have a table with a column for each of the 12 months in the year. A summary sheet shows the totals for the month selected and also the totals for the year-to-date using the same selected month. The User selects the month from a dropdown box.

I need some code to use the selected month in the sum() calculation for another worksheet. Problem is that sum() doesn't appear to want to accept a named cell (or more probably that I don't know how to write it to do this).

My calculation looks like this:

=sum('budget'!$f19:'budget'!namedmonth9)

where 'budget' is a different sheet and "namedmonth" is the letter corresponding to the column of the user selected month.

I have got a macro to work as required, but this won't sit within this and many other cells and update when the user selects a different month.

Any help will be most appreciated.

Many thanks for your prompt replies, my problem is now solved and whatismore, I even understand the code!

Something new to learn every day.

Carim,

Can you please tell me how to produce the dropdown box in cell A5 of your example, I thought that I had done this in the past, but now cannot find out how to do it?

Many thanks

ValleyWatch

Carim,

Thank you once again, your help is much appreciated.

Regards

ValleyWatch