Mashtonsmith
Board Regular
- Joined
- Oct 1, 2004
- Messages
- 164
Hello...
I need a simple Marco please.
I have a worksheet full of duplicate entries. In most cases the "duplicate" is only over two rows, but occasionally 3.
Where the identifyer cahnges I need a blank row inserted.
e.g.
TN123456A
TN123456A
TN434343A
TN343434A
TY323232A
TY323232A
Needs to look like
TN123456A
TN123456A
TN434343A
TN343434A
TY323232A
TY323232A
i.e. broken up with a new (blank) row.
I need a simple Marco please.
I have a worksheet full of duplicate entries. In most cases the "duplicate" is only over two rows, but occasionally 3.
Where the identifyer cahnges I need a blank row inserted.
e.g.
TN123456A
TN123456A
TN434343A
TN343434A
TY323232A
TY323232A
Needs to look like
TN123456A
TN123456A
TN434343A
TN343434A
TY323232A
TY323232A
i.e. broken up with a new (blank) row.