+ Reply to Thread
Results 1 to 3 of 3

Excel Header Update when specific cell changed

  1. #1
    Registered User
    Join Date
    07-02-2012
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    6

    Excel Header Update when specific cell changed

    Hello all,

    I am currently trying to have the center header update based on two cell values. The one cell updates based off of another cells value and that is what needs to be updated in the header. I'd like it to update only when that specific cell updates and not each time a cell in the sheet in changed. Here is what I currently have but nothing seems to be working properly.

    Please Login or Register  to view this content.
    C22 is the cell that I'm typing into and changes the value of W2. V2 and W2 are what I want to appear in the header.

    Thanks for the help.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Excel Header Update when specific cell changed

    Use this line instead

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-02-2012
    Location
    NJ
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Excel Header Update when specific cell changed

    That worked. I guess it was just a simple little thing.

    Thanks, stnkynts!

+ 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] Automatic update of a cell every time another one is changed
    By Romoluzzi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2013, 09:52 AM
  2. copy header and rows toa specific excel range cell
    By karthikin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-07-2012, 12:45 PM
  3. Replies: 1
    Last Post: 07-26-2006, 02:44 PM
  4. Replies: 0
    Last Post: 07-26-2006, 10:05 AM
  5. Can the header margins be changed in excel
    By cartridgeworld in forum Excel General
    Replies: 2
    Last Post: 01-02-2006, 11:30 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