louise1
08-20-2017, 02:18 AM
Hi everyone,
I'm puzzled by this problem and hoping someone can help.
I have a large file of data. In some of the lists ‘Settings’ is listed twice and sometimes Settings is listed once.
In a Macro, is there any way off adding an extra row below beneath ‘Settings’, if it’s not already duplicated. (It would be great if this extra row could include the word Settings)
A few screenshots are below for my example.
20121
It would be great if the above data, could look like
20122
If anyone can help that would be amazing, Thanks!
I'm puzzled by this problem and hoping someone can help.
I have a large file of data. In some of the lists ‘Settings’ is listed twice and sometimes Settings is listed once.
In a Macro, is there any way off adding an extra row below beneath ‘Settings’, if it’s not already duplicated. (It would be great if this extra row could include the word Settings)
A few screenshots are below for my example.
20121
It would be great if the above data, could look like
20122
If anyone can help that would be amazing, Thanks!