+ Reply to Thread
Results 1 to 8 of 8

Jump to specific column if cell contains value 2019

  1. #1
    Forum Contributor
    Join Date
    05-10-2016
    Location
    SF
    MS-Off Ver
    Excel 2016
    Posts
    136

    Jump to specific column if cell contains value 2019

    Hi,

    If the cell AU8 contains value 2019 I would like the cursor to jump to column 99 and after select the cell CU9

    Trying this code with no luck.

    Please Login or Register  to view this content.
    Thanks for any help I can get.
    B.

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,805

    Re: Jump to specific column if cell contains value 2019

    Use
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Forum Contributor
    Join Date
    05-10-2016
    Location
    SF
    MS-Off Ver
    Excel 2016
    Posts
    136

    Re: Jump to specific column if cell contains value 2019

    Hi YasserKhalil,

    Thanks for the fast reply. It works.

    All the best.
    B.

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,805

    Re: Jump to specific column if cell contains value 2019

    You're welcome. Glad I can offer little help

  5. #5
    Forum Contributor
    Join Date
    05-10-2016
    Location
    SF
    MS-Off Ver
    Excel 2016
    Posts
    136

    Re: Jump to specific column if cell contains value 2019

    Hi,

    Can this work if the cell AU8 is a dropdown with different values.
    If I change the value so it goes to specific column?

    All the best.
    B

  6. #6
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,805

    Re: Jump to specific column if cell contains value 2019

    You can put your code in Worksheet_Change event so as to put all your possible conditions and values and their related columns

  7. #7
    Forum Contributor
    Join Date
    05-10-2016
    Location
    SF
    MS-Off Ver
    Excel 2016
    Posts
    136

    Re: Jump to specific column if cell contains value 2019

    Hi,

    You are right, after puting the code in Worksheet_Change event it works.
    Thanks again.

    All the best.
    B.

  8. #8
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,805

    Re: Jump to specific column if cell contains value 2019

    You're welcome. Glad I can offer little help

+ 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. Using Dropdown to jump to specific cell
    By billio75 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2018, 12:28 PM
  2. [keyboard shortcut] jump to last cell in column
    By boarders paradise in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 08-04-2017, 02:04 PM
  3. [SOLVED] If answer Yes on a dropdown box, jump to a specific cell?
    By trenzalore888 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-26-2016, 02:50 PM
  4. how to jump into a specific cell
    By excelrio in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 08-07-2016, 10:18 PM
  5. [SOLVED] Make the cursor jump from the last cell of column C to the first cell of column L
    By JOAO12 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-09-2013, 11:47 AM
  6. Need macro to jump to specific cell determined by date.
    By mhelmers in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2012, 06:19 PM
  7. jump to specific date in cell-range based on last opening of workbook
    By wamp in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-20-2008, 09:06 AM

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