+ Reply to Thread
Results 1 to 2 of 2

How to automated this?

  1. #1
    Registered User
    Join Date
    07-15-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to automated this?

    Item 1
    If column A hv value then column C "Pending"
    If column A and B hv value then column C "Completed"
    If A and B no value then C is blank.

    Item 2
    If copy and paste in column A then column B will automatically timestamp.

    Thanks

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: How to automated this?

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Automated hyperlinks
    By aint in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2010, 09:22 AM
  2. Automated PDF Creator
    By mjwillyone in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2010, 11:17 AM
  3. automated spreadsheet
    By cooksey2000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2010, 07:36 PM
  4. Automated Linking
    By deejayh in forum Excel General
    Replies: 0
    Last Post: 05-04-2006, 08:26 AM
  5. automated print to pdf
    By Gixxer_J_97 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2005, 04: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