Dear Excel Power users/Gurus,

I am new user of this forum and have seen some great postings in the past. Bravo to all the gurus out there who are helping people like me.

I have very limited knowledge of VBA in Excel however, I have seen the example below in past. I would like to seek your help in creating a simple VBA code that can be added to the command button in the spreadsheet.

I have a table listing various carriers (103). I have colums showing weeks. The values are volume for these carriers by weeks. I have carrier's volume for the last year and forecast volume for this year. I want to create graph/chart by carrier automatically stored in an excel spreadsheet on c:\Graphs with carrier name as a file name (E.g. Carrier1.xlsx, carrier2.xlsx,etc). This will allow me to email all these carriers individually thier expected forecast volume compared to last years actual volume.

Please find the attached example file herewith (only 2 carriers) :Generate Charts using VBA.xlsx

The forecast might change in near future and hence will need VBA code behind a simple push button which will create updated excel files with graphs by carrier under the c:\Graphs folder.

I would sincerely appreciate your help. Thank you for your time in advance. please let me know if you have any questions.

DMS