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
|