Hi board
I have a spreadsheet with 1000's of records in the format :-
Date Job Ref Count
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 by Job Ref & Count in each line break?
Any assistance would be gratefully received!!
I have a spreadsheet with 1000's of records in the format :-
Date Job Ref Count
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 by Job Ref & Count in each line break?
Any assistance would be gratefully received!!