Hi All,
I have an excel sheet as follows :
a b
1Supp1 Code1
2Supp2 Code2
This is repeated for 1000 rows. Now question is how do I add 3 empty rows for each supplier line until the end of the supplier line by using Macro ?
Meaning results should be as follows :
a b
1Supp1 Code1
2
3
4
5Supp2 Code2
6
7
8
9Supp3 Code3
Hope to hear from you all soon.
Cheers for now.
I have an excel sheet as follows :
a b
1Supp1 Code1
2Supp2 Code2
This is repeated for 1000 rows. Now question is how do I add 3 empty rows for each supplier line until the end of the supplier line by using Macro ?
Meaning results should be as follows :
a b
1Supp1 Code1
2
3
4
5Supp2 Code2
6
7
8
9Supp3 Code3
Hope to hear from you all soon.
Cheers for now.