I want to have a summary sheet to pull information depending on the selections from a drop down list. So if Janurary is selected from the drop down I want the cells to display the data relating to that month. I have the workbook set up with a worksheet for each month.
I am using this forumla: -
=COUNTIF('Oct 08'!V1:V8930,"G*")
But I want the 'Oct08' to change depending on the month selected?
Any ideas?
Bookmarks