how do i copy values between tables using relative formulas

  • Thread starter Thread starter ther00k
  • Start date Start date
T

ther00k

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.
 
ther00k said:
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.
Click to expand...

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?
 
Back
Top