How can I insert a new cell with value in a specific position based on sorted column in excel?
As example if I have this sorted data in a column.
abc
abcd
abcde
abcdefg
abcdefgh
And I want to insert a new cell with value abcdef.
The result should be.
abc
abcd
abcde
"abcdef"
abcdefg
abcdefgh
How could to achieve that using VBA ?