Attached is my .xls with dummy data forum.ozgrid.com/index.php?attachment/57013/.
My intention is that once the Director and Month in tab 'By Director & Month' is chosen and the Fetch Data commandbutton is clicked, a new workbook should open.
This new work book should have :
- all entries in tab 'Monthly Invoice Input' for that Director-Month combination,
- along with a sum total of column Q(Total invoice amount) in the last row.
Is this possible?