+ Reply to Thread
Results 1 to 2 of 2

Customize autofill

  1. #1
    Registered User
    Join Date
    12-21-2007
    Location
    Szeged, HUNGARY
    MS-Off Ver
    2013
    Posts
    42

    Customize autofill

    Hi all,
    In Excel Help it is:
    "If the first few characters that you type in a cell match an existing entry in that column, Excel automatically enters the remaining characters

    Instead of that column

    Is it possible somehow to extend the range to another column in a different sheet?

    Thanks in advance

    KausBorealis

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,865

    Re: Customize autofill

    I don't think that is possible.. But maybe you can let Autofill generate the desired result, and maybe copy it to the sheet you need..

    This probably can be done with VBA, where you put the main list in a Combo Box, which suggests you words based on the initial characters.
    Last edited by NeedForExcel; 04-29-2016 at 03:12 AM.
    Cheers!
    Deep Dave

+ 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. Customize Autofill Feature
    By goodguygreg in forum Excel General
    Replies: 9
    Last Post: 07-02-2015, 04:12 PM
  2. Autofill base on Active Cell and Autofill by row count of another sheet
    By enyak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2014, 10:06 PM
  3. Macro for Autofill removes header info when there is no data to autofill
    By esturan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2012, 01:42 PM
  4. customize colors
    By Coqui in forum Excel Formulas & Functions
    Replies: 51
    Last Post: 09-06-2005, 07:05 PM
  5. Customize Autofill
    By BigMeg in forum Excel General
    Replies: 1
    Last Post: 08-03-2005, 12:05 PM
  6. Replies: 1
    Last Post: 06-17-2005, 04:05 PM
  7. Replies: 0
    Last Post: 03-02-2005, 12:06 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