Hi All -

I have a set of data in which for each time the text occurs "Customer Name Total", I need to move down 2 rows, insert a row and either paste a series of labels and formulas there or just format that row to say "YTD Conversion Total" with a series of formulas out to the right. For example, "Customer Name Total is in F10 and for that instance, I would need to move down to cell F12, insert a row and then in column F, I need it to say "YTD Conversion Total" and then on the same row in columns G,H,I,J,K,L,M,N,O,P,Q,R, I need it to have a formula referencing data above. Ideally, I could just use something along the lines of Find "Customer Name Total" and for each instance, move down 2 cells, insert and then write the macro to format that row accordingly; however, I need to loop that to where it moves on to the next "Customer Name Total" and as easy as I'm sure this is, I can't seem to figure it out.

Can someone help?