Hi there,
I am trying to learn VBA / Macro's but am finding it difficult to apply the following to a large data spreadsheet.
I would be grateful for your help?
Please see attached for a sample of the data.
I have data in columns E, O, S and U which changes. What I would like to do automatically is when the value changes, insert a new blank row to separate them.
For example, a blank row to be inserted under row 4, 6, 9, 10, 235 etc. There is approx. 12,000 rows and there is no consistency in the number of rows before a unique value appears.
Is this possible? It can be based on 1 column as far as I am aware.
Many thanks for your help.
Regards
N
Bookmarks