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.