Results 1 to 7 of 7

Date Stamp needed when data is entered into a Column by external workbook

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    988

    Date Stamp needed when data is entered into a Column by external workbook

    Hello All,

    I have been looking for a Date stamp that will enter the current date when data is entered into a column.

    Is there a formula that will put the current date in row 2 above the data being submitted (Column B) from a different workbook each time a column data has been entered.

    Each time a submission is made new data is entered into the next Column to the right... So a Date stamp is needed above each Column as it is entered.

    The attached workbook shows the section needed

    Thoughts are appreciated!

    Regards,

    John
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula Needed to count data in a column based on certain data entered into another
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-08-2017, 11:56 PM
  2. [SOLVED] if data is entered in column A, column B should have date automatically entered.
    By exceltriumph in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-30-2016, 12:02 PM
  3. Date stamp of last external data refresh
    By shabbir2812 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-14-2016, 01:46 PM
  4. Date stamp on column A when data is entered in either column C to Z
    By Kanook22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-06-2012, 01:49 PM
  5. Links use name of external workbook entered once?
    By leaning in forum Excel General
    Replies: 1
    Last Post: 04-19-2012, 12:27 PM
  6. Auto Date Stamp Column A when data in Column B
    By medihx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2011, 06:56 PM
  7. [SOLVED] bringing data from one workbook to another using a date stamp func
    By tifosi3 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-04-2005, 08:06 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