Thank you charlesdh,

I have attached a test example. I have set up a command button in the sheet 'Overhead Analysis' which opens the sheet 'TranDetail' and sets some filter criteria but they are just fixed at the moment. I would like them to be set based on the corresponding values relative to the active cell in the Overhead Analysis sheet when the button is pressed.

Thanks

Attached Files

Test reporting tool.xlsm (54.3 KB, 13 views)