I have a work book that has several sheets, I would like to reference a cell from the 1st sheet and use it in a middle of a cell that has text in it. I want to put it in a certain point within the text string.
This is the text string:
Effective this 1st day of July, 2005 and continuing in force thereafter for a period of one year unless terminated as hereinafter provided, company (the "Seller") agrees to provide covered services, as per attached schedule of services for which ############# (the "Buyer") agrees to pay the annual sum of _______________.
I want to put the sheet "Info Sheet" cell A4 where the ##### is.
Thanks in advance.
This is the text string:
Effective this 1st day of July, 2005 and continuing in force thereafter for a period of one year unless terminated as hereinafter provided, company (the "Seller") agrees to provide covered services, as per attached schedule of services for which ############# (the "Buyer") agrees to pay the annual sum of _______________.
I want to put the sheet "Info Sheet" cell A4 where the ##### is.
Thanks in advance.