Insert rows and enter data in blank cells.

[jscalem]

Hello :-) I am trying to put together a macro and I am stuck!!!

I need to add 3 rows at each change in the data in column C. Within those new rows I need some rows to fill down and some to enter new text and some to enter a formula.

I have attached the example with a before and after tab.

The data in yellow on the "after" tab will be a vlookup formula to another workbook and the data in green will be a formula. Otherwise the data will either fill down or will be specific data as shown.

[dluhut]

Hey Jscalem,

I believe you'd need a loop here.

First try to determine the "last row"

Secondly, when there's a change in the column C data, insert 3 rows below it.

Third, "go to" the next data BEFORE the insert row. i.e. Before insert, the data was on row 2, now that you've insert the 3 rows, you need the code to go to row 5 to check the data and if there's a change in column C, insert, if not go to the next row, until the "last" row that you've found.

[jscalem]

I am not familiar with working with loops. I know the code to go to the last row of data. With this portion of the macro I am kind of lost. I have gotten as far as to be able to insert the rows and copy down the data but it copies all of the data not just specific columns.

[jscalem]

Also the number of rows will vary from one month to the next. So there could be 10 companies or there could be 100 companies.

[dluhut]

That's what I by determined the "last row" so that, doesn't matter what month this macro runs on, it will "know" what's the last month is. please check you PM

[arlu1201]

dluhut,

Do you have the solution / code? Can you please post it here?