Graham Hill
New Member
- Joined
- Apr 11, 2002
- Messages
- 2
I have several rows of text which look as follows:
LONDON
eng
eng
GLASGOW
sco
sco
I need a macro to autofill from the top row and then skip the missing cell to autofill the next block. This list is about 5000 rows so the macro will have to always find the next block and fill it until there is no more data.
LONDON
eng
eng
GLASGOW
sco
sco
I need a macro to autofill from the top row and then skip the missing cell to autofill the next block. This list is about 5000 rows so the macro will have to always find the next block and fill it until there is no more data.