| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i copy the result of a formula into another worksheet as te
But that results in a linking formula.
OP wanted values only. Why not paste specialvalues? Gord Dibben MS Excel MVP On Thu, 6 May 2010 02:50:07 -0700, trip_to_tokyo wrote: EXCEL 2007 Assuming that your, "text formula in one worksheet" is in Book1 cell D4. Go to Book2 cell D4 (or any cell of your choice) type in:- =[Book1]Sheet1!$D$4 Book2 cell D4 will now be populated with, "the resulting text into another worksheet". If my comments have helped please hit Yes. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy formula down - cell references change - result is same for al | Excel Worksheet Functions | |||
| copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
| How do I copy a check box result from Worksheet A to Worksheet B? | Excel Worksheet Functions | |||
| Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) | |||
| How do I copy a result without copying the formula? | Excel Discussion (Misc queries) | |||
Hybrid Mode
