macro-auto copy and insert a header based on the contents of the c

**janjan_376** · 09-01-2010, 02:44 PM

Please help me with this scenario:

I would like to create a macro that will automatically copy and insert a header based on the contents of the cell.
.
A1:J1 (is the header)
A2:A4 = has value
A5 = BLANK
A6:A14 = has value
A15 = BLANK
and so on....

I would like to copy the header (a1:j1) and insert in between A4 and A6...and so on. Please help. Thank you.

**JBeaucaire** · 09-01-2010, 03:13 PM

Try this:

Please Login or Register  to view this content.

**janjan_376** · 09-01-2010, 04:22 PM

Hi, Thank you for your response and time. I did apply the macro and it worked perfectly. I really appreciated your help. Thank you, thank you.

**JBeaucaire** · 09-01-2010, 06:13 PM

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

macro-auto copy and insert a header based on the contents of the c

LinkBack

Thread Tools

Rate This Thread

Display

macro-auto copy and insert a header based on the contents of the c

Re: macro-auto copy and insert a header based on the contents of the c

Re: macro-auto copy and insert a header based on the contents of the c

Re: macro-auto copy and insert a header based on the contents of the c

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions