+ Reply to Thread
Results 1 to 3 of 3

Auto insert in a column

  1. #1
    Registered User
    Join Date
    08-20-2011
    Location
    Barcelona,Spain
    MS-Off Ver
    Excel 2007
    Posts
    1

    Red face Auto insert in a column

    Hi,

    I am new on this forum, my question is, How can I auto insert a value in a cell.

    Letīs say:

    A1 is 2001L
    B1 is John

    All I want is whenever I put 2001L in Colum A , it will auto complete in colum B as John

    X.JPG

    Thank you
    Last edited by Camarlengo; 08-20-2011 at 06:40 AM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    26,828

    Re: Auto insert in a column

    Hi,

    Not quite sure if this is what you mean but assuming you mean for any entry in column A, then the adjacent entry in column B should be John, try in B1 and copied down.

    Please Login or Register  to view this content.
    Regards
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    08-10-2011
    Location
    Michigan, USA
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Auto insert in a column

    If you were satisfied with your answer please mark the thread solved, directions below:

    To mark your thread solved do the following:
    - Go to the first post
    - Click edit
    - Click Advance
    - Just below the word "Title:" you will see a dropdown with the word No prefix.
    - Change to Solve
    - Click Save
    When helped,use the icon right of the post #.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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