brennaboy
08-06-2010, 05:20 AM
Hi,
Just wondered if someone might be help me tackle the following problem using VBA in Excel.
I have a list of data which is in date order. I want to do a macro so that will add a blank line between groups of data with different dates.
E.g.
05/08/2010
05/08/2010
06/08/2010
10/08/2010
10/08/2010
10/08/2010
The macro would then go down the list and check to see when the date differs from the previous one and then the list would become:
05/08/2010
05/08/2010
06/08/2010
10/08/2010
10/08/2010
10/08/2010
Hope that makes sense.
Any ideas?
Bren.
Just wondered if someone might be help me tackle the following problem using VBA in Excel.
I have a list of data which is in date order. I want to do a macro so that will add a blank line between groups of data with different dates.
E.g.
05/08/2010
05/08/2010
06/08/2010
10/08/2010
10/08/2010
10/08/2010
The macro would then go down the list and check to see when the date differs from the previous one and then the list would become:
05/08/2010
05/08/2010
06/08/2010
10/08/2010
10/08/2010
10/08/2010
Hope that makes sense.
Any ideas?
Bren.