mattster1010
07-01-2008, 05:58 AM
Afternoon All,
I have a spreasheet that holds a field called 'Enquiry Number'. I have sorted the spreadsheet by Enquiry Number and usually there are two records always grouped together, one for a created date, the other for a closed date.
I want to be able to seperate the first two records with a blank line, then the next two records etc etc. how would I do this using VB with a command button.
Any help would be appriecated.
Regards,
Mattster
I have a spreasheet that holds a field called 'Enquiry Number'. I have sorted the spreadsheet by Enquiry Number and usually there are two records always grouped together, one for a created date, the other for a closed date.
I want to be able to seperate the first two records with a blank line, then the next two records etc etc. how would I do this using VB with a command button.
Any help would be appriecated.
Regards,
Mattster