+ Reply to Thread
Results 1 to 4 of 4

timestamp after entry of data

  1. #1
    Registered User
    Join Date
    08-08-2007
    MS-Off Ver
    Excel 2010
    Posts
    53

    timestamp after entry of data

    I have a macro that is picking up information from rows in column A then searching for information online with that info.
    Once it finds the result it pastes the results in the corresponding row in column B.
    what i'm looking to add to this existing macro is the following.

    After each result is pasted into column B i'd like the corresponding row in column C to show the time that information was pasted into column B

    Would need to do this for each row until it reaches the bottom of the file..

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: timestamp after entry of data

    add something like this to your macro:=

    Please Login or Register  to view this content.
    You would need to change the c in C6 to match your paste row

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-08-2007
    MS-Off Ver
    Excel 2010
    Posts
    53

    Re: timestamp after entry of data

    unfortunatly that won't work.
    The macro i have loops... so picks up the data A2, searches. pastes the results in B2
    macro then loops back to the begining of the macro and picks up data from A3, searchs. pastes the result in B3
    and so on. does this for aprox 90, 000 rows.

  4. #4
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: timestamp after entry of data

    Submit your macro

+ 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. [SOLVED] inserting a timestamp on the data sheet when a raw data file is imported
    By macrorookie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2014, 02:18 PM
  2. VBA that enters TIMESTAMP after data entry, then locks it
    By MichState in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2013, 01:39 PM
  3. VBA timestamp that locks unlocked cells in range upon entry
    By twhite in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-13-2012, 12:42 AM
  4. When a timestamp doesn't behave as a timestamp
    By mredekopp in forum Excel General
    Replies: 3
    Last Post: 03-07-2011, 03:39 PM
  5. Excel formula timestamp for a data entry of a referenced cell
    By jmasaki in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-02-2006, 09:25 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