View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joerg Joerg is offline
external usenet poster
 
Posts: 138
Default 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