+ Reply to Thread
Results 1 to 6 of 6

Name maanger for one frozen row (name/id) and other cells

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    MS 2016
    Posts
    430

    Name maanger for one frozen row (name/id) and other cells

    Hi guys,

    Is there a way I can use name manager for my spreadhseet, where I use an ID (column A) or name (column B) to create columns as part of name maanger for each month.

    I.e Column C, is May 2020. I have 3 columns with the holiday pay, total (for work pay), then a column for holiday + total.

    I want to have name manager to show: Holiday pay for john in may, total (for work pay) in may for john, holiday + total in may for John.

    Then I can create this for the other employees and repeat this process for other months.

    I need this to easily calculate accruals over more than 1 month. Rather than doing cell references.

    Any help appreciated pls!
    Attached Files Attached Files
    Thanks,

    R.



  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    39,216

    Re: Name maanger for one frozen row (name/id) and other cells

    I read this yesterday and have done so again fresh this morning and I'm really not clear what the issue is. The answer is yes, you can create named ranges for any range you wish to specify, but you can't automate it - you'd need to do it manually.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    MS 2016
    Posts
    430

    Re: Name maanger for one frozen row (name/id) and other cells

    Hi Ali,

    Sorry I don't intend to automate anything but I know that if I can have name manager defined for each month's 3 columns for each employee, this would be really helpful for me and what i`m trying to achieve

    I.e Column C, is May 2020. I have 3 columns with the holiday pay, total (for work pay), then a column for holiday + total.

    I want to have name manager to show: Holiday pay for john in may, total (for work pay) in may for john, holiday + total in may for John.

    Once i know how i can do this for john for may, I will repeat the process for another individual for the month of may, then repeat this process for the individuals in june

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    39,216

    Re: Name maanger for one frozen row (name/id) and other cells

    Are you simply asking how to create named ranges?

  5. #5
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    MS 2016
    Posts
    430

    Re: Name maanger for one frozen row (name/id) and other cells

    Hi Ali,

    Not necessarily

    so let's try this approach please

    see this imge, how can I do a name maanger for this range(each column) to show it relates tyo john for the month of may?

    then i can repeat this process for other employees and others. months.

    Thanks!
    Attached Images Attached Images

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    39,216

    Re: Name maanger for one frozen row (name/id) and other cells

    Click on the cell containing John's May holiday payment - with this cell selected, change the name box top left (where it shows the cell reference (e.g. D2)) to something like John_May_Holiday. Rinse and repeat for all other cells you want to have as named ranges.

    I'm still not sure if this is what you mean, and I am absolutely sure there's a less labour-intensive way of structuring your formulae, but with such scant information, it's impossible to advise further.

+ 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. Copying cells from a frozen pane
    By d3ell in forum Excel General
    Replies: 7
    Last Post: 01-09-2019, 04:07 PM
  2. [SOLVED] Open workbook to todays date. with frozen cells
    By nub9l in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-21-2017, 10:03 AM
  3. Page # of # in frozen cells
    By 8OutOf10Dogs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-20-2014, 12:58 PM
  4. Frozen cells - not responding
    By ordinateur in forum Excel General
    Replies: 8
    Last Post: 05-21-2009, 10:29 AM
  5. Frozen panes won't stay frozen
    By Irshlas in forum Excel General
    Replies: 0
    Last Post: 03-12-2009, 03:15 PM
  6. Printing Frozen Cells Automatically on every page
    By gin2000 in forum Excel General
    Replies: 2
    Last Post: 07-17-2006, 01:14 PM
  7. comments mouseover on frozen cells
    By T-ReXTC in forum Excel General
    Replies: 1
    Last Post: 02-09-2006, 06:21 AM

Tags for this Thread

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