Need a code or formula that will automatically change the named range in my formulas

Hi everyone,

I'm looking for a code or a formula that I can use in the attached workbook. In the "Month" tab I have formulas that reference named ranges from the "Summary" tab. Each named range is named for a different month of the year. What I'd like is to have the named range referenced to automatically change to the month that I type in cell C1 on the "Month" tab. I know I can do a find/replace with Excel's built in tool, but I'm trying to make it easier for other people that would be using this workbook.

It would be great if it would change just by entering a new month in C1 of the "Month" tab, but a pop-up window or macro embedded button asking for which month to change to would work too.

Any help someone can provide would be greatly appreciated.

Hi

Month!B5: =INDEX(INDIRECT($C$1),5 )

See how that goes.

rylo

Like a charm! Thank you very much. This forum is an absolute life saver.