How to input entire contents from a cell in 'sheet 3' into a sentence in a cell in sheet 1

[neilg71]

I'm writing a standard quotation in excel and would like to have all the variable data on a separate sheet. See example below.

"The machine will be used to assist with the (Sheet 3:H2) operation of raw material goods."

In cell H2 of Sheet 3 I will input operation type to be incorporated into the quotation.

Any help with making this happen would be appreciated.


Neil

[Lemice]

Hello,

Perhaps like this

Please Login or Register  to view this content.

Is this what you are looking for?