Inserting Text to a sentence in a cell from a cell on another sheet

[Excel_Assis]

Hi could anyone help please with a formula to say on Sheet1 cell A1 insert part of a sentence from Sheet 2 C1 and also fill other parts of the sentence from another cell Say F1. But the formula then needs to auto increment the row number from Sheet 2 by 1.

I have done this and it works but no auto increment of source row number.

="<div><b>Type:&nbsp;</b> "&Sheet2!$D$3&" </div><div><br> </div><div><b>Model:&nbsp;</b>"&Sheet2!$H$3&"</div><div><br> </div><div><b>Year Preferred:</b>&nbsp;"&Sheet2!$I$3&" &nbsp; </div>"

In this sample formula I need the 3 to increment automatically down the column.

 

[Legacy 143009]

$ sign is used to lock referances. Remove $ from rows in order to make them relative.

="<div><b>Type:&nbsp;</b> "&Sheet2!$D3&" </div><div><br> </div><div><b>Model:&nbsp;</b>"&Sheet2!$H3&"</div><div><br> </div><div><b>Year Preferred:</b>&nbsp;"&Sheet2!$I3&" &nbsp; </div>"

 

[Excel_Assis]

$ sign is used to lock referances. Remove $ from rows in order to make them relative.

="<div><b>Type:&nbsp;</b> "&Sheet2!$D3&" </div><div><br> </div><div><b>Model:&nbsp;</b>"&Sheet2!$H3&"</div><div><br> </div><div><b>Year Preferred:</b>&nbsp;"&Sheet2!$I3&" &nbsp; </div>"

Hi thanks for the speedy reply. However how does that allow the formula to auto increment the row number from Sheet 2. Example 3 would change to 4 the 4 change to 5 as in keeps populating the rows on Sheet 1

Apologies I get it now you can just drag down the column and the row increments. Thank so much.

 

[Legacy 143009]

No worries Take care