+ Reply to Thread
Results 1 to 5 of 5

Help needed with autocomplete

  1. #1
    Registered User
    Join Date
    06-10-2021
    Location
    Bucharest, Romania
    MS-Off Ver
    365 for business
    Posts
    2

    Help needed with autocomplete

    Hello everyone,

    Please advice me (or help me) with something:

    I receive daily a excel document with 3 columns:
    First is Name, Second is Kind of Activity, Third one is Time expressed.
    In the first column I have the name of worker, in the second I have on different rows different activites and on the third is hours...
    The problem is name of worker is put only in the first row while I need to have the same name for every activity in the second column, and for every worker could be a different number of rows (a different number of activities). So my question is if I can make it automatically to autocomplete name of the worker for every row in activity, depending of how many rows are.

    I attached a sample of my file

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,007

    Re: Help needed with autocomplete

    you either have a helper column
    in d2 =if(a2<>"",a2,d2)

    or use power query to fill in the gaps

  3. #3
    Registered User
    Join Date
    06-10-2021
    Location
    Bucharest, Romania
    MS-Off Ver
    365 for business
    Posts
    2

    Re: Help needed with autocomplete

    Thank you for the quick answer...it's not working with the helper column.
    Can you provide more with how to use power query to fill the gaps?

    Thank you

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,598

    Re: Help needed with autocomplete

    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,007

    Re: Help needed with autocomplete

    I like the vba approach above but
    =if(a2<>"",a2,d1) in d2 and copy down, you may need to change , to ; for your region

    I am no powerpivot expert, so would struggle to help you there.

    attached is the other solution in a workbook, just press the button
    Attached Files Attached Files

+ 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. Autocomplete different on Mac?
    By AchtungCloud in forum Excel General
    Replies: 0
    Last Post: 11-27-2014, 01:49 AM
  2. Replies: 1
    Last Post: 11-16-2008, 02:54 PM
  3. IDE autocomplete
    By RMJames in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2006, 08:25 AM
  4. [SOLVED] autocomplete?
    By Gary in forum Excel General
    Replies: 1
    Last Post: 07-18-2005, 09:05 PM
  5. Replies: 0
    Last Post: 01-04-2005, 09: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