+ Reply to Thread
Results 1 to 3 of 3

Select range based on dates (collumns) and names (rows)

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    Ardooie
    MS-Off Ver
    Excel 2007
    Posts
    67

    Question Select range based on dates (collumns) and names (rows)

    Hi All,


    I'm looking for a vba code to do following in the example sheet I attached:

    - Inputbox to select the start date (col)
    - Inputbox to select the end date (col)
    - Inputbox to select the driver (row)

    Nothing explains it better than an example from the worksheet:
    I'd like to get following range selected: G9:I9.
    This has to happen based on the input the user gives:
    start date = 03/01/2020
    end date = 07/01/2020
    name = driver2

    I hope I explained it well
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,729

    Re: Select range based on dates (collumns) and names (rows)

    See how next code can help
    Please Login or Register  to view this content.
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    10-17-2013
    Location
    Ardooie
    MS-Off Ver
    Excel 2007
    Posts
    67

    Re: Select range based on dates (collumns) and names (rows)

    That is brilliant, works like a charm !!!

    Tyvm PCI !!!

+ 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. Select Sheets based on named range list of sheet names
    By cchen212 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-07-2017, 06:12 PM
  2. Select range of rows based on cell value
    By amitmodi_mrt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2017, 08:03 AM
  3. Insert rows in between a range from another range based on dates
    By siprem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2016, 09:01 AM
  4. [SOLVED] Need IF statement (inside of Linest Function) that will select range based on dates
    By cpkrehbiel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-07-2014, 09:22 PM
  5. [SOLVED] Macro that will select range based off cell value in multiple rows
    By hambly in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-09-2013, 03:05 PM
  6. [SOLVED] Hide select rows based on value in a dynamic range
    By rhiminee in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-21-2013, 01:19 PM
  7. [SOLVED] Macro that will select range based off cell value in multiple rows
    By hambly in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-14-2013, 09:12 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