+ Reply to Thread
Results 1 to 4 of 4

Automatically insert data and date

  1. #1
    Registered User
    Join Date
    03-25-2015
    Location
    Lawrenceville, GA
    MS-Off Ver
    2013
    Posts
    2

    Automatically insert data and date

    Hi,

    I need help with macro that automatically insert data and Date in excel columns. In my column K, the choice either Yes or No. If the value in Column K is Yes, I would like Column A = TAKEN and Column O = Static Date. If the value in Column K = No, I would like Column A = MISSING and Column O clear. Thanks in advance for the help.

  2. #2
    Valued Forum Contributor
    Join Date
    11-12-2014
    Location
    Nottingham
    MS-Off Ver
    2013
    Posts
    383

    Re: Automatically insert data and date

    Try this:

    Please Login or Register  to view this content.
    !If all your troubles are solved, then so is the thread. Show this by marking it so using thread tools at the top of the page.
    If I helped do this, then please show your appreciation by awarding rep points.
    <------ Button for that is over there

  3. #3
    Registered User
    Join Date
    03-25-2015
    Location
    Lawrenceville, GA
    MS-Off Ver
    2013
    Posts
    2

    Re: Automatically insert data and date

    Hi ARowBot,

    The Date does not appear in Row O.

  4. #4
    Valued Forum Contributor
    Join Date
    11-12-2014
    Location
    Nottingham
    MS-Off Ver
    2013
    Posts
    383

    Re: Automatically insert data and date

    It does for me... Make sure it says exactly "Yes" if that is a problem then change the code accordingly.

+ 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. Insert and remove data automatically with the date
    By manos77 in forum Excel General
    Replies: 5
    Last Post: 10-14-2011, 01:43 PM
  2. Insert Date Automatically
    By bobzroom in forum Excel General
    Replies: 3
    Last Post: 05-06-2009, 09:35 AM
  3. Replies: 6
    Last Post: 11-07-2008, 01:19 PM
  4. Automatically insert a STATIC date/time if data in adjacent cell
    By BrightsideScott in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2007, 09:11 AM
  5. Insert date automatically
    By MikeA in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-03-2005, 06:05 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