Changing Titles by a formula

H

Heather

From cell A1:A10 I have standard titles that are linked to
another sheet. I only need to change the office and date
per each title. Is thier a way to do that making the
office and date a formula in another cell?

example of title

ABC Comp, Office 38L Sales as of 6/07/2004

I need to only keep changeing the 38L and date.

Any suggestions----Thanks
 
S

Simon Shaw

Say Office # is in Column 'C'

in cell A1:
="ABC Comp, Office "&C1&" Sales as of "&Today()


----- Heather wrote: -----

From cell A1:A10 I have standard titles that are linked to
another sheet. I only need to change the office and date
per each title. Is thier a way to do that making the
office and date a formula in another cell?

example of title

ABC Comp, Office 38L Sales as of 6/07/2004

I need to only keep changeing the 38L and date.

Any suggestions----Thanks
 
Top