Macro/Code to duplicate a range of formatted cells based on data

**nico67** · 10-25-2012, 08:39 PM

Hi,

I need help to figure out the following:

In the attached example, first tab contains a range of formatted cells which I need to fill with the data from the second tab.

It will be perfect when adding a row of data in sheet 2 a new box with the formatted cells gets populated down in sheet 1.

My sample shows 2 lines of rows already populated but not the 3rd. I would like to avoid copy and paste the formatted cells as I don't know how many rows of data sheet 2 will contain.

Is it possible to do that, if yes could you please help me?

Thanks very much!

**arlu1201** · 10-26-2012, 01:05 PM

If i understand you correctly, you want one section to be created (from scratch) in Sheet1 which gets populated from Sheet2?

Do we have to do the color formatting in sheet1 too? Or can the section A4:P15 in sheet1 just be duplicated for each row in sheet2?