+ Reply to Thread
Results 1 to 5 of 5

Shortcut

  1. 02-04-2019, 06:30 AM #1
    arindamsenaxa is offline
    Registered User
    Join Date
    11-28-2014
    Location
    india
    MS-Off Ver
    7
    Posts
    143

    Shortcut

    I just wanted to create a shortcut to go to in that table.
    as the date will change frequently so we cannot name the table as per the dates.
    so I just want that whatever date I choose in C2, if that is is an existing table, it should go automatically over there.

    Ex:- as of now the date in C2 is 3rd Jan, so I can able to see the table which is starting from line no 42.

    or else if there is any other simple way around, please do let me know.

    File:- Countif formula.xlsx


    If this is possible it will save my time while maintaining this

    Regards
    Arindam
    Reply With QuoteRegister To Reply
  2. 02-04-2019, 07:48 AM #2
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,620

    Re: Shortcut

    welcome to the forum

    For future reference, please take a moment to read the forum rules and use thread titles that are descriptive of your problem - not what you think the answer might be. (think google search terms?).

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 02-04-2019, 10:54 AM #3
    Roel Jongman is offline
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,494

    Re: Shortcut

    I have a bit quick and dirty solution that will only work accurately as long as the block of analysts have 16 names..

    Please Login or Register  to view this content.
    where 8 is startrow of first data block
    17 = 16 analyst+1 blankrow for each date
    the datevalue formula calculates how many days we are into 2019 and jumps x days * 17 down..
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 02-11-2019, 02:14 AM #4
    arindamsenaxa is offline
    Registered User
    Join Date
    11-28-2014
    Location
    india
    MS-Off Ver
    7
    Posts
    143

    Re: Shortcut

    Thanks Its working
    Reply With QuoteRegister To Reply
  5. 02-11-2019, 02:14 AM #5
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,897

    Re: Shortcut

    Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

    • Use concise, accurate thread titles.
    • Your post title should describe your problem, not your anticipated solution.
    • Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
    • Responding to a request to change your thread title by doing so is mandatory.

    To change a title go to your first post, click EDIT then Go Advanced and change your title.

    No help to be offered, please, until the OP complies with this request.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] ShortCut
    By billisnice in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-27-2015, 11:38 AM
  2. Shortcut for the doubleclick fill and general keyboard shortcut questions
    By Vaslo in forum Excel General
    Replies: 3
    Last Post: 02-21-2014, 10:19 AM
  3. using alt as a shortcut key/list of symbols for shortcut keys
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2010, 09:12 AM
  4. VBA shortcut
    By Vittorio in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-21-2009, 03:18 AM
  5. [SOLVED] Shortcut key
    By Steph in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-01-2006, 03:15 PM
  6. [SOLVED] Shortcut
    By Steph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2005, 08:05 PM
  7. [SOLVED] Shortcut into Name box
    By Bonnie in forum Excel General
    Replies: 2
    Last Post: 03-04-2005, 12:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1