Hi all,
I am relatively new to VBA and I am working on a project where I want my VBA code to find the bold text in a column and copy that bold text and the following text until coming upon the next bold text. Then take that text to a new sheet and transpose paste it into rows with the bold text being the first in the row. Here is an example of what I need:
1
2
3
4
5
6
7
8
vba code runs and result is:
1, 2, 3,4
5, 6, 7, 8
Any help would be greatly appreciated!
Edit: added example spreadsheet for reference
I am relatively new to VBA and I am working on a project where I want my VBA code to find the bold text in a column and copy that bold text and the following text until coming upon the next bold text. Then take that text to a new sheet and transpose paste it into rows with the bold text being the first in the row. Here is an example of what I need:
1
2
3
4
5
6
7
8
vba code runs and result is:
1, 2, 3,4
5, 6, 7, 8
Any help would be greatly appreciated!
Edit: added example spreadsheet for reference
Attachments
Last edited: