Thread: how do i copy the result of a formula into another worksheet as te
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote