| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
| Invisable text in formula bar | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
Linear Mode
