PC Review


Reply
Thread Tools Rate Thread

how do i copy values between tables using relative formulas

 
 
ther00k
Guest
Posts: n/a
 
      20th Dec 2007
I've created a workbook in Excel 2007 and I'm trying to use the copy feature
to insert relative formulas into several adjacent cells by draging the
relative formula one one cell into several adjacent cells. While the
resulting formulas are corret the relative values are not.
 
Reply With Quote
 
 
 
 
Stephen
Guest
Posts: n/a
 
      21st Dec 2007
"ther00k" <(E-Mail Removed)> wrote in message
news:C6D1E27D-F83B-4A3E-9725-(E-Mail Removed)...
> I've created a workbook in Excel 2007 and I'm trying to use the copy
> feature
> to insert relative formulas into several adjacent cells by draging the
> relative formula one one cell into several adjacent cells. While the
> resulting formulas are corret the relative values are not.


I think you will need to be more precise.

What is the formula you are using?
Which cell do you type this into?
What is the data in the cells referenced by this formula?
What is the result of the formula?

Which cell do you copy the formula to (or an example if there are many)?
What is the resulting formula?
What is the data in the cells referenced by this new formula?
What is the result of this new formula?
What do you expect the result to be?


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy without relative formulas changing murphyobrien@gmail.com Microsoft Excel Discussion 10 15th May 2006 08:38 PM
Relative vs. Absolute Values in Formulas Microsoft Excel Worksheet Functions 1 23rd Jan 2004 02:31 AM
How to Copy Formulas not Values ... Ronnie Microsoft Excel Programming 2 23rd Oct 2003 08:37 AM
Range COPY function - how to copy VALUES and not formulas James Cooke Microsoft Excel Programming 1 21st Aug 2003 07:04 PM
Range COPY function - how to copy VALUES and not formulas James Cooke Microsoft Excel Worksheet Functions 1 21st Aug 2003 07:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:40 AM.