+ Reply to Thread
Results 1 to 2 of 2

My formula is not changing a 'month' when using named range

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    My formula is not changing a 'month' when using named range

    Hi all,

    mY TAB DATA_Dashboard, cell D4 should be changing the value currently listed as january to the month selecteed from the list on the left.. under b16 can anyone advise why cell D4 does not change values.. ie it says summary for month january. I want it to show summary for month july, if july is selected from the list on the left

    thank you
    Attached Files Attached Files
    Thanks,

    R.



  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: My formula is not changing a 'month' when using named range

    Name manager

    List_Month
    =Lists!$D$4:$D$15

    TAB DATA_Dashboard, cell D4

    ="Summary for month "&Lists!D2
    Attached Files Attached Files

+ 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. [SOLVED] Set variable range Sheet named month and 4 diferent ranges in each month.
    By clixo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2020, 07:24 AM
  2. Named Range Name Keeps Changing On Its Own
    By ezrizer in forum Excel General
    Replies: 5
    Last Post: 04-23-2014, 01:05 AM
  3. [SOLVED] SUMPRODUCT with Named Range and Month
    By fgruhlke in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2014, 06:16 PM
  4. [SOLVED] Changing the Named Range in Vlookup
    By Kevets in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-21-2013, 12:10 AM
  5. Changing Name of Predefined Named Range
    By agentred in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-15-2012, 05:46 PM
  6. Excel 2007 : Named range keeps changing
    By Kenny Bones in forum Excel General
    Replies: 5
    Last Post: 07-08-2011, 10:53 AM
  7. VBA Changing a named range
    By Obfuscated in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2011, 10:05 PM

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