I would like to create a summary page with the 3 month rolling average of
sales.
I have all the sales, profit and salesperson data compiled on 1 worksheet.
I would like to use a drop down menu on the summary (already set it up by
months) to choose a month of the year and then have the average of the
previous 3 months data displayed.
Is this possible? and if yes, How?