Results 1 to 13 of 13

Thread: Named Cells

  1. #1
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts
    in the Attached Spreadsheet I have named Cells D4 thru D12, plus D14
    I have also named Cell H3, all is well to this point
    Now I want to name Cells H4:H12 BalanceForward

    Here is what I did:
    Name Manager
    New
    Name: BalanceForward
    Refers to: Highlited Cells H4:H12
    Closed Refers to
    Clicked OK

    It didn't work. What am I [attachment=91081:Test 01.xlsx]doing wrong?
    Attached Files Attached Files
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Hello - When I want to name a range, I highlight the area to be named and then in the white box (range name box) above column A, I type in the name.
    In this case, highlight H4 thru H12 and then type BalanceForward in the range name box.

    See attached modification.
    Also note that a tab has been added to display all the Range Names and their locations.

    Hope that helps.
    Attached Files Attached Files

  3. #3
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts
    thanks Tim,
    I re read my post and see that I should have put in that I need to be able to subtract cell all the way down. In other words H5-D6, and so forth but I want The cells in Column H to all read BalanceForward.
    And now that I look at it I don't see how that can work......
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    T8ntliky,

    It seems what you want is to use Balance Forward as a column title which should make it clear to the reader what is going on. Why do you want the cells to be named BalanceForward? If it is so your formula can read =BalanceForward - H5, etc. I think you're out of luck as you can only have one cell/range per sheet with a given name. Thus, you could name H4:H12 as BalanceForward but it will refer to the whole range not individual cells in the range. Of course you probably already understand this but just in case.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  5. #5
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts
    RG,
    Thanks for reaffirming the conclusion that I came to as well

    John
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    If you select the cell H5 and insert - name define:
    Name:
    BalanceForward

    RefersTo:
    ='Dec. 2010'!H4

    You can use the name "BalanceForward" to refer the cell above. So in H5 you can put:
    =BalanceForward-D5
    And copy it down the column

    Steve

  7. #7
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Quote Originally Posted by t8ntlikly View Post
    thanks Tim,I re read my post and see that I should have put in that I need to be able to subtract cell all the way down. In other words H5-D6, and so forth but I want The cells in Column H to all read BalanceForward.And now that I look at it I don't see how that can work......
    t8ntlikly - In the example above, it is not clear why the name BalanceForward is necessary or wanted. Can you elaborate?


    Am I missing something?

    Thanks,
    Tim

  8. #8
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts
    Nope that is the reason Tim.. But I think that BalanceForward-E5 will work out just dandily
    thanks to all who replyed
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  9. #9
    Star Lounger
    Join Date
    Jan 2002
    Location
    Minneapolis, Minnesota, USA
    Posts
    54
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Tim - How did you create the worksheet that lists the range names?

  10. #10
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Quote Originally Posted by slrosen View Post
    Tim - How did you create the worksheet that lists the range names?
    You can use a new sheet or a blank area of an existing sheet and then do the following.....
    Insert>Name>Paste>Paste List. Then, adjust column widths as needed.

    Hope that works for you.

  11. #11
    Star Lounger
    Join Date
    Jan 2002
    Location
    Minneapolis, Minnesota, USA
    Posts
    54
    Thanks
    4
    Thanked 0 Times in 0 Posts
    That works just fine. I'm in Excel 2010, so the procedure is a little different, but the result is what I wanted. It's Formula Ribbon > Use in Formula > Paste Names > Paste List.

    Thanks,

    -Stuart

  12. #12
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Stuart - My procedure was done in Excel 2003. Thank you for posting the procedure for Excel 2010.

    Tim

  13. #13
    Star Lounger
    Join Date
    Jan 2002
    Location
    Minneapolis, Minnesota, USA
    Posts
    54
    Thanks
    4
    Thanked 0 Times in 0 Posts
    You're welcome. Thanks for the help.

    -Stuart

Posting Permissions

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