Hi everyone,

I have an excel file that has data for different items throughout the year. What I'm trying to do is get averages per month per item and write it at the bottom of the file. I am doing this by connecting to a SQL Server and "plotting" the data in the excel sheet. This is what I have so far:
Please Login or Register  to view this content.
I've tried to do it using Select Case but I can't think of how to relate the individual months with the individual comments.

Any ideas are much appreciated.

Xhuljano