+ Reply to Thread
Results 1 to 9 of 9

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

  1. #1
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    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. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,882

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



  3. #3
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

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

    sheet attached
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,882

    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. #5
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    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. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,882

    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?
    Attached Files Attached Files

  7. #7
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    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.
    Attached Files Attached Files

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,882

    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. #9
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

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

    Thanks Glenn Kennedy

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and Paste Chart and Data // Want Relative References, Not Absolute
    By AdamParker in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-25-2014, 12:05 PM
  2. [SOLVED] F4 key does not toggle relative/absolute cell references.
    By Ron de Bruin in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 03:05 PM
  3. [SOLVED] F4 key does not toggle relative/absolute cell references.
    By java in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  4. [SOLVED] Relative/absolute cell references
    By Jan Kronsell in forum Excel General
    Replies: 2
    Last Post: 05-09-2005, 10:06 AM
  5. [SOLVED] Absolute vs. Relative Cell References
    By ChrisR in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2005, 08:06 PM

Bookmarks

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