+ Reply to Thread
Results 1 to 4 of 4

Auto Fill 6 cells based of of text in one other cell

  1. #1
    Registered User
    Join Date
    02-24-2014
    Location
    Lodi, ca
    MS-Off Ver
    Excel 2013
    Posts
    2

    Auto Fill 6 cells based of of text in one other cell

    I am looking for a VB code to perform the following:

    If text in Column C is "DDC" or "VOID".... I would like column K, M, O, Q, S and T to auto populate with the same wording and leave blank if any other text is in column C or if it is blank. A formula will not work for this because of the end use of this spreadsheet.

    C K M O Q S T
    DDC DDC DDC DDC DDC D DDC
    VOID VOID VOID VOID VOID V VOID

    so it would look similar to the above but in excel obviously.

    Please help!

  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,873

    Re: Auto Fill 6 cells based of of text in one other cell

    Try this:

    Please Login or Register  to view this content.
    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

  3. #3
    Registered User
    Join Date
    02-24-2014
    Location
    Lodi, ca
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Auto Fill 6 cells based of of text in one other cell

    Thanks that works!

    Can you add the coding that makes the macro run as cells are updated?

  4. #4
    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,873

    Re: Auto Fill 6 cells based of of text in one other cell

    Put this in the worksheet change event and not in a module.

    Please Login or Register  to view this content.

+ 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. auto fill cells based on 1st cell
    By teagranny in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2014, 09:36 AM
  2. VBA auto fill cell based on text above it
    By adamheon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2014, 11:22 AM
  3. How to auto-fill text based on Value'8000,8001' in another cell
    By Shimazu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2014, 05:51 AM
  4. Replies: 2
    Last Post: 11-29-2012, 11:27 AM
  5. How to auto-fill text based on text in another cell
    By Jason in forum Excel General
    Replies: 2
    Last Post: 02-16-2005, 04:37 PM

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