Summary for VLOOKUP Invoices

[ccampb1346]

Many thanks to jaslake for the help in my last projects.

I'm looking to build off the attached spreadsheet a summary spreadsheet that would deposit various data (volume, revenue, etc.) about each meter into one format for internal use.

The attached spreadsheet (Copy of Processing Forecast Model v5.2.xlsm) is updated monthly and then the program is run and it runs through all of the static data and saves all the results as PDF files for each customer, very neat.

Since the data changes every month I would like for a program to deposit the results of the model into a summary spreadsheet by month.

Hopefully the following would occur:
1. In a new spreadhseet titled "Processing Forecast Model - Internal Summary" each month would have it's own tab in the format (MMYY ie. 0413) the month will correspond to the B1 cell on the "pricing' tab on the Copy of Processing Forecast Model v5.2.xlsm spreadsheet
2. The results from the model would populate for each meter that month, one row for each meter in much the same format as the 'meter' tab on the Copy of Processing Forecast Model v5.2.xlsm spreadhsheet
3. Each month a new tab will be created in the "Processing Forecas Model - Internal Summary" spreadsheet with a new tab as described above

I've attached a sample for the new summary spreadhsheet and included it in the attachment, but ideally would prefer that it lives in a separate spreadsheet.

As always, your help is appreciated.