Hi All

I have set up an Ageing Statement in sheet1 which contains Invoice Listing for a customer. This data is pulled from Sheet2 and is extracted through Index Function. Based on the number of value in a specific Cell in Sheet 2, the data gets refreshed in Sheet1.

I need a VBA Code to do the following,

1) VBA code to generate the statement for each customers based on cell input in Sheet 2
2) Upon refreshing each statement, the active sheet needs to be saved a new file with pre-allocated name picking up from a specific range in the statement sheet.

Any help is much appreciated.

Thanks

Mysore