Putting words in a sentence

[Mjh35]

What I would like to do is write a sentence on sheet 3 in a work book an insert a word from a cell on sheet1
Something like to supply ( the word in a11 on sheet 1 ) colour ( the word in a12 sheet1 ) is this possible
Many thanks

[Pete_UK]

Give us some concrete examples of what you have and what you are trying to achieve - see the yellow banner at the top of the screen for details of how to attach a workbook to one of your posts.

Pete

[Mjh35]

here is the work book

[Glenn Kennedy]

So.... what do you expect to see? Where do you expect to see it??

[Mjh35]

Hi Glen
I would like to see on sheet 3 line 24 To supply and fit ( sheet1!a11 ) colour ( sheet1!a12)
So what ever I type into a11 and a12 appears in that sentence

[Glenn Kennedy]

Maybe this??

=IF(Sheet1!A11="","","To supply and fit "&Sheet1!$A$11&" colour "&Sheet1!$A$12&".")

Both Sheet 1 A11 and 12 are blank in your sheet.

[Mjh35]

here a copy of the work book

[torachan]

In sheet3 cell A24 - ensure something in sheet1 cells A11 & A12

Please Login or Register  to view this content.

[Mjh35]

Yes thanks works a treat

[Glenn Kennedy]

That is the same workbook as at post 1 and that I used at Post 6??!!!!