+ Reply to Thread
Results 1 to 2 of 2

MACRO needed to auto populate fields if an X is placed in a specific field

  1. #1
    Registered User
    Join Date
    10-31-2012
    Location
    Canton, MI
    MS-Off Ver
    Excel 2010
    Posts
    5

    MACRO needed to auto populate fields if an X is placed in a specific field

    If user enters X in say, Cell F4, I then need Cells A6:A10 and A12:A20 to auto populate with N/A. I know how to create the macro to auto fill manually but how can I make it update automatically the cells to N/A if X is marked in other cell? Thank you!

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: MACRO needed to auto populate fields if an X is placed in a specific field

    Under the worksheet module, perhaps, try

    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)

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