# copy to row and in column with Relative and Absolute Cell References

1. ## copy to row and in column with Relative and Absolute Cell References

i want to calculate 3 values in d15 col I have a formula =a1*a2*\$a\$3 and drag down upto d25
but in column d16 to m16 my formula changed to =\$A\$1*\$B\$1*D15 and drag to m16 which I changed manually.
from a1 to \$a\$1 first and then drag.
D15 E 15 F15
=A1*B1*\$C\$1 =\$A\$1*\$B\$1*D15 =\$A\$1*\$B\$1*E15
=A2*B2*\$C\$1
=A3*B3*\$C\$1

is there any formula to not to change this manually as my range of data is very large.

2. ## Re: copy to row and in column with Relative and Absolute Cell References

I am not able to understand what you want. can you please attach an Excel sheet, clearly showing the problem & the desired end result.

3. ## Re: copy to row and in column with Relative and Absolute Cell References

sheet attached

4. ## Re: copy to row and in column with Relative and Absolute Cell References

The formula in E15 copies across perfectly. What do you want to happen in row 16??

5. ## Re: copy to row and in column with Relative and Absolute Cell References

Sir, at D15 the formula is =A1*B1*\$C\$1 and drop down to D24 but in the row D16:M16 I have to change this formula manually =\$A\$1*\$B\$1*D15 before stretch it to M16. So at E16 to E24 first I have to change this manually as above and then stretch to M16 to M24.

6. ## Re: copy to row and in column with Relative and Absolute Cell References

There is something in your description that I am not clear about. So... is this what you wnated (drag E15 down and then drag E15:E24 across.

If not what EXACTLY do you want in E15 and what EXACTLY do you want in E16?

7. ## Re: copy to row and in column with Relative and Absolute Cell References

Sir, Here is the result which I want. You can see that column D15:D24 copy to E15:E24 and then put the sign of \$ to change absolute manually at E15,E16,E17,E18...E24.

8. ## Re: copy to row and in column with Relative and Absolute Cell References

All is clear now, I hope. Paste this into E15 and drag down and then across.

=\$A1*\$B1*D15

9. ## Re: copy to row and in column with Relative and Absolute Cell References

Thanks Glenn Kennedy

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1