Results 1 to 4 of 4

Name Range - Relative Reference

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-10-2007
    Posts
    106

    Name Range - Relative Reference

    Hi,

    attached you will find a sample..

    Could you please help me out, how can i copy the cell C10 to D10 so that name range changes aswell. When copied the formula with Class1 (Range 1) right next it should sum the name range class2 (Range 2)
    I know the name ranges are absolute reference and it cant be modified when copied down.
    Is there a trick to make it relative Reference.. i want to keep the added Name Definitions untouched.

    Thanks
    Attached Files Attached Files
    Last edited by Sultix; 12-30-2012 at 12:32 PM.

Thread Information

Users Browsing this Thread

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

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