Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Macro to copy the header from column B and to repeat to other rows until the next header appears

0

Hi Team,

I have a column B which has a Header and below the header there are sub headers and the sub headers has its own descriptions. What I would like to have is, copy the sub header to column A and copy that to below cells until the next sub header appears in column B.

I have attached the sheet which hopefully let you know what I am looking for.

First sheet: How the worksheet looks like before running macro

Second sheet: How I am expecting the worksheet should look like after macro

Thanks,

Karthik

Answer
Discuss

Discussion

Will the heading always begin with "Karthik" or will it always be 5 cells down, or both?
don (rep: 1989) Mar 10, '17 at 7:44 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login