+ Reply to Thread
Results 1 to 7 of 7

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

  1. 01-16-2022, 11:06 AM #1
    JJFletcher is offline
    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
    Reply With QuoteRegister To Reply
  2. 01-16-2022, 11:16 AM #2
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

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

    RU OK with VBA as a solution?
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 01-16-2022, 11:24 AM #3
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    988

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

    Hi Glenn,

    Thank you so much for your response... Yes I am Ok with VBA !!

    Thank You

    Regards,

    John
    Last edited by JJFletcher; 01-16-2022 at 11:30 AM.
    Reply With QuoteRegister To Reply
  4. 01-16-2022, 11:41 AM #4
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    988

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

    Glenn,

    Do you have a VBA solution you wish to share?


    Thanks
    Reply With QuoteRegister To Reply
  5. 01-16-2022, 11:44 AM #5
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,392

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

    It has been 19 minutes since you posted to say that a VBA solution was OK. Please be patient!
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  6. 01-16-2022, 11:47 AM #6
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    988

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

    Ali,

    My apologies please!

    I had assumed by the question from Glenn that he had a solution ready to share so thus my question to him.

    I was not trying to be precipitous in anyway!

    I am looking for VBA that can put the Date Stamp above the Column Data

    Here is an image below...

    Regards,

    John
    Attached Images Attached Images
    Last edited by JJFletcher; 01-16-2022 at 02:51 PM.
    Reply With QuoteRegister To Reply
  7. 01-16-2022, 02:52 PM #7
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    988

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

    Attached Image to previous comments
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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. 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1