Hi,
I have a spreadsheet with multiple records Eg.
01/09/2006 JOB2 3,500
01/09/2006 JOB2 10000
01/09/2006 JOB2 100
01/09/2006 JOB3 10
01/09/2006 JOB3 100
Could you tell me how I use VBA to insert a line when the Job number changes and then total up the end column by Job?
Thanks
I have a spreadsheet with multiple records Eg.
01/09/2006 JOB2 3,500
01/09/2006 JOB2 10000
01/09/2006 JOB2 100
01/09/2006 JOB3 10
01/09/2006 JOB3 100
Could you tell me how I use VBA to insert a line when the Job number changes and then total up the end column by Job?
Thanks