+ Reply to Thread
Results 1 to 3 of 3

Paste-Special Time & Date on Data Entry

  1. #1
    Registered User
    Join Date
    12-14-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    7

    Post Paste-Special Time & Date on Data Entry

    Hello!

    Please see attached spreadsheet.

    Should anything be entered into the green, I would like the time and date 'pasted' into the adjoining blue.

    =NOW() is in B2 (just so you're not doubling-up)

    Regards
    Craig


    Example Data Input.xlsx
    Last edited by MrCraig; 11-02-2013 at 08:34 AM.

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Paste-Special Time & Date on Data Entry

    Disregard

    Fotis1991 is correct.
    Last edited by Winon; 10-28-2013 at 03:10 AM.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Paste-Special Time & Date on Data Entry

    Hello to you.

    You need a timestamp for this. You can use formula or VBA.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ 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. paste special for date value
    By harishoy in forum Excel General
    Replies: 1
    Last Post: 09-30-2013, 08:42 AM
  2. [SOLVED] Userform for date entry and then copy/paste matching data to another sheet
    By nymanns in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-06-2013, 03:22 AM
  3. Special Paste data using VBA to date specific column
    By JuliaBird in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2012, 09:24 PM
  4. Paste Special throwing error first time
    By sid_misra in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2010, 02:12 PM
  5. Replies: 1
    Last Post: 04-03-2008, 05:33 AM

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