I have a large number of accounts listed down column B, (1 account could have any number of rows). Up untill now i have used "subtotal" to split each account to a seperate sheet when printing.
But i would like to be able to email this sheet to the client.....
So how do i split each line that matches an account number (could be 200 different accounts) to another workbook and save by the account number and name (from column A).
Keeping the same titles in the first 3 rows and a total in column C.
But i would like to be able to email this sheet to the client.....
So how do i split each line that matches an account number (could be 200 different accounts) to another workbook and save by the account number and name (from column A).
Keeping the same titles in the first 3 rows and a total in column C.
