Hi there

I have a sheet as follows below. I need to code a VBA macro that will copy the subheading cell and ID (B3 and C3 in example) on to each row of the content (A4:B4, A5:B5). A new column B will need to be inserted. The number of content rows can vary. There is always a blank line between each section. The number of sections can also vary.

Before:
Before.JPG

After:
After.JPG

I have managed to copy when there is a fixed number of lines in each section and a fixed number of sections, but unsure how to do it when there is multiple lines and sections.

Any help you may be able to offer would be greatly appreciated.

Many thanks
Richard