how do i copy values between tables using relative formulas

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.
 
S

Stephen

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula problems 2
Conditionally format: Only if unique identifier and exceeds % of previous record 0
Copy cells to different sheet if value found 1
Dependent "If" formulas 2
Adding Quote Marks To A Very Long Column. How, Please ? 1
return a formula instead of a value of a cell 2
I need to cut characters off of a list of text cells... 2
How do I copy an array formula? 1

Top