Closed Thread
Results 1 to 2 of 2

VLOOKUP: Auto-complete a column (48 cells long) from a dropdown box

  1. #1
    Registered User
    Join Date
    04-04-2016
    Location
    Auckland, New Zealand
    MS-Off Ver
    MS Office 2013
    Posts
    4

    VLOOKUP: Auto-complete a column (48 cells long) from a dropdown box

    Hi everyone

    Apologies in advance, I'm certain someone as already answered this question. I'm trying to create a timesheet. I'll describe what it needs briefly - the first column will be a list of times (10 minute blocks), 48 cells in total (for 8 hours). Column 2 will be blank, so the user can enter "Client Name", column 3 a dropdown list called "Activity" for the user to choose from.

    We have 3 different start times; 8:00am, 8:30am and 9:00am. I am wanting to make a drop down box of these start times (For example, in A2), and when a time is selected (eg 8:00am), cells A3, A4 etc will auto complete from there (8:10am, 8:20am).

    I've tried using VLOOKUP with a separate sheet holding the 3 columns of different start times, but I just can't seem to wrap my head around it and I'm quite stuck.

    I work with people who are extremely computer illiterate, so I'm trying to make the process of recording time in our office as easy as possible! Any help at all would be greatly appreciated!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,887

    Re: VLOOKUP: Auto-complete a column (48 cells long) from a dropdown box

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto-complete limited to 121 cells?
    By twobob in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2014, 11:17 PM
  2. Auto Complete from patterns from different column
    By jyothijayanna in forum Excel General
    Replies: 1
    Last Post: 08-04-2013, 12:12 PM
  3. Replies: 4
    Last Post: 02-25-2013, 05:27 PM
  4. How do I auto complete cells?
    By sonars in forum Excel General
    Replies: 3
    Last Post: 04-24-2009, 06:01 AM
  5. auto complete for dropdown lists
    By RERICE in forum Excel General
    Replies: 4
    Last Post: 11-26-2006, 02:52 PM
  6. [SOLVED] Combo Box - auto complete and the bound column/text column propert
    By jeffbert in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-29-2006, 05:35 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