Re: $$Excel-Macros$$ What am I missing????

Outstanding!!! Works perfectly. Thank you very much. Steve On 4/10/2014 10:02 AM, ashish koul wrote: ignore the previous one and try ths one =SUM(OFFSET(A3,0,0,1,MATCH(ReportPeriod,$A$1:$M$1,0))) On Thu, Apr 10, 2014 at 7:30 PM, ashish koul > wrote: try t

Re: $$Excel-Macros$$ dynamic drop down list

Thank you Ashish!!! It's very close . . . 1. Could you explain how to add new years to the drop down list? The three most current years are missing. 2. Can the date shown in the chart be automatically updated to show the period from which the data was used? Thank you so much for your help