Prefacing a Copy/Paste Special formula with text
 

Hi folks,

I've got two workbooks linked. Am trying to pull a date from one workbook
into another, and would like to preface the copy/paste special data with "As
of" in the cell.

Can anyone suggest a fix?

TIA,

Bob

Prefacing a Copy/Paste Special formula with text
 

Not sure what you mean: Why would you copy/paste special if the sheets are
linked?
Otherwise a link such as: ="As of "&Sheet2!A1
Joerg

"Bob Smith" wrote in message
link.net...
Hi folks,

I've got two workbooks linked. Am trying to pull a date from one workbook
into another, and would like to preface the copy/paste special data with
"As
of" in the cell.

Can anyone suggest a fix?

TIA,

Bob