(Msg. 1) Posted: Wed Jun 27, 2007 9:28 am
Post subject: How do I copy a formula from one worksheet to another? Archived from groups: microsoft>public>excel>newusers (more info?)
I have a formula in one worksheet and want to copy that result to a cell in
another worksheet. When I try to do that, I get "#REF#" in the destination
cell. How can I make this work?
(Msg. 2) Posted: Wed Jun 27, 2007 5:48 pm
Post subject: Re: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"cahduq" <cahduq RemoveThis @discussions.microsoft.com> wrote in message
news:B6A6EE7C-B925-4FCE-B2EE-D8F8D6B601D3@microsoft.com...
>I have a formula in one worksheet and want to copy that result to a cell in
> another worksheet. When I try to do that, I get "#REF#" in the
> destination
> cell. How can I make this work?
>
(Msg. 3) Posted: Wed Jun 27, 2007 6:28 pm
Post subject: RE: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi
If you only want the result in another tab and don't care if it is next to
the sourse data, just cut and paste it to the tab you want it in. That will
preserve the relationship to the data.
Norm
normbenish.RemoveThis@hotmail.com
"cahduq" wrote:
> I have a formula in one worksheet and want to copy that result to a cell in
> another worksheet. When I try to do that, I get "#REF#" in the destination
> cell. How can I make this work?
(Msg. 4) Posted: Sun Jul 01, 2007 9:30 am
Post subject: Re: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Would it not be better to reference the cell where the formula is in case
the results change?
"cahduq" <cahduq.RemoveThis@discussions.microsoft.com> wrote in message
news:B6A6EE7C-B925-4FCE-B2EE-D8F8D6B601D3@microsoft.com...
>I have a formula in one worksheet and want to copy that result to a cell in
> another worksheet. When I try to do that, I get "#REF#" in the
> destination
> cell. How can I make this work?
(Msg. 5) Posted: Fri Sep 14, 2007 1:40 pm
Post subject: Re: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
How do you reference the cell? I have tried numerous times and cannot get it
right.
Thanks
"Gail Richner" wrote:
> Would it not be better to reference the cell where the formula is in case
> the results change?
>
>
> "cahduq" <cahduq.DeleteThis@discussions.microsoft.com> wrote in message
> news:B6A6EE7C-B925-4FCE-B2EE-D8F8D6B601D3@microsoft.com...
> >I have a formula in one worksheet and want to copy that result to a cell in
> > another worksheet. When I try to do that, I get "#REF#" in the
> > destination
> > cell. How can I make this work?
>
>
>
(Msg. 6) Posted: Fri Sep 14, 2007 2:31 pm
Post subject: Re: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
If all you want is the result, just copy then paste special>value.
You could on target sheet use =sourcesheet!A1
Or select the cell to copy and edit>replace
What: =
With: ^^^
Copy the cell to next sheet then reverse the process.
Gord Dibben MS Excel MVP
On Fri, 14 Sep 2007 13:40:01 -0700, Que <Que.TakeThisOut@discussions.microsoft.com> wrote:
>How do you reference the cell? I have tried numerous times and cannot get it
>right.
>
>Thanks
>
>"Gail Richner" wrote:
>
>> Would it not be better to reference the cell where the formula is in case
>> the results change?
>>
>>
>> "cahduq" <cahduq.TakeThisOut@discussions.microsoft.com> wrote in message
>> news:B6A6EE7C-B925-4FCE-B2EE-D8F8D6B601D3@microsoft.com...
>> >I have a formula in one worksheet and want to copy that result to a cell in
>> > another worksheet. When I try to do that, I get "#REF#" in the
>> > destination
>> > cell. How can I make this work?
>>
>>
>>
(Msg. 7) Posted: Fri Sep 14, 2007 10:36 pm
Post subject: Re: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
One way
In the destination cell, type "=" (without quotes),
click on the sheet tab of the cell that you wish to reference,
click on the cell that you wish to reference,
press 'Enter'.
George Gee
"Que" <Que.DeleteThis@discussions.microsoft.com> wrote in message
news:41AC19F3-FF4E-450B-B9E4-71C0B07B1420@microsoft.com...
> How do you reference the cell? I have tried numerous times and cannot get
> it
> right.
>
> Thanks
>
> "Gail Richner" wrote:
>
>> Would it not be better to reference the cell where the formula is in case
>> the results change?
>>
>>
>> "cahduq" <cahduq.DeleteThis@discussions.microsoft.com> wrote in message
>> news:B6A6EE7C-B925-4FCE-B2EE-D8F8D6B601D3@microsoft.com...
>> >I have a formula in one worksheet and want to copy that result to a cell
>> >in
>> > another worksheet. When I try to do that, I get "#REF#" in the
>> > destination
>> > cell. How can I make this work?
>>
>>
>>
(Msg. 8) Posted: Mon Apr 13, 2009 6:09 am
Post subject: RE: How do I copy a formula from one worksheet to another? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"cahduq" wrote:
> I have a formula in one worksheet and want to copy that result to a cell in
> another worksheet. When I try to do that, I get "#REF#" in the destination
> cell. How can I make this work?
All times are: Eastern Time (US & Canada) (change) Goto page 1, 2
Page 1 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office