Hi All,

I've been putting together a basic financial report utility that imports data for a specific cost centre using SQL and does a whole range of array formulas in a predefined layout and does some nice little charting.

This utility then copies the 'cover page', 'Report' and 'Data' tab to a new workbook as values only. Saves the file and then emails the newly created workbook to whomever it needs to go to.

The managers have asked for something which has got me scratching my head. I know it can be done as I've seen it done before. Essentially, what they want to do is to be able to click on a given 'chart account' and filter the transactions based on what they've selected.

My thoughts are....

If a user 'double clicks' on a row, it will 'auto filter' the data based on the value in column H and the row they've clicked on "if there is a code available"

I think the best way forward, to make it simple for the users is to just have the 'Data' filter based on what is selected.

The next thing I need to do is copy the VBA module to the new workbook.

Any tips would be sincerely appreciated.