timestamp

Hi I have a workbook with three sheets named respectively A, B and C. Each sheet is formatted the same way (same template based). Only the content changes. I would like to write in VBA that, when a change occurs in the active sheet, the cell B1 which is the date, changes to the current...

Hello, I am currently working unto something and I need a timestamp. The logic is that if A1 is not blank then today will present in A2. However, date and time in A2 must not change if for example I fill out the fields in cell B2 - E2. Can someone help me please?

Hi guyz i have been google for days trying to find solution to put time-stamp and sound when condition meet. i really hope all expert excel user here can help me. This is what i want to do: eg: =IF((F9="SELL")*AND(H9="GOOD"),"SELL"&"",IF((F9="BUY")*AND(H9="GOOD"),"BUY")) It will trigger...

Greetings All! I'm with a team who uses excel to keep track of events, start & end times etc. We use excel now but everyone has to type in the times manually. I'd like to make a sheet that would have buttons next to the cells where the time needs to go, and if they click the button it would add...

Hello! I'm attempting to create a summary on a google sheets response form. There are multiple entries of the same item, but with an updated location for each entry. What I would love, is for the formula to look up the item, search for the most recent entry (each row will have it's own...

Hi All, I send out emails via a macro. All of the emails' information are found in the workbook. What I would like to do next is once an email is sent out, is there a way to return a value to column L? It would simply be something to just let me know that the email was actually sent out, and if...

Hello All, I am trying to make a button that combines the value in one cell and adds the current date and time and places it in a new cell. So basically I am trying to take the text in C3("Completed At") and then add the date and time that the macro was run. Any assistance would be greatly...

I would like a date & time timestamp to generate in column J when columns C, D, E,F, G, H, or I are updated in that same row. I am tracking status on 33 rows.

Hi, I'm trying to make a timestamp in B2 when cell A1 is updated by a formula. Thanks

Hello! I'm new to vba in excel and understanding the language & i need help with my user form :confused: I have created a form that acts like a Log Form to track who goes into a room. In my form I have two command buttons that allow users to Submit Entry & Log Off. The Submit Entry button...

Using Excel 2007 I receive a daily data dump in a specific file directory that has a time stamp in the form of "Name yyyy_MM_dd_hhmmss.csv" Because the timestamp is not consistent, I am struggling to create a macro that can pickup the correct file from the folder. Is there a macro that i can...

Hi, I've created a userform where people capture information and have to time the process for the work that they are doing. The information is then transferred to the worksheet and the data moves down the next row. using the following code: Range("A10:V10").SelectRows(10).Insert...

Hi, I have created some VBA code to run my spreadsheet. The code works perfectly. However, I have a cell on a worksheet called "Data" the cell is D14 that I would like populated with the date and time that the macro started to run. I am struggling with this code. I have pasted my code...

Hi I'm trying to calculate the difference in times on a userform. I have a start time, pause, continue and end times which are entered using time stamps with the NOW() funtion. I've calculated but it returns an actual "hour" rather than the time difference. I'm completely new at this and now...

I need to create a VBA code for a spreadsheet I am working on where if data is entered, or the cell is modified in any aspect, then a timestamp will appear in the cell under it. For example, if cell B1 or B2 was modified (data entry or whatnot), then in cell B4 a timestamp would appear. I...

Hi, Good day. Could anyone here provide a code that will automatically create a timestamp (date:time) on a specific cell on the cue of cell input then automatically timestamp on the next cell upon saving a document. timestamp for input will only be done once. then timestamp before exit will...

Hi there, I have created an excel spreadsheet with some fairly extensive VBA code (for my standards anyway), and it seems there are some significant propagation delays. I believe the biggest delay is stemming from a range of cells that have a timestamp recorded when data is entered into the...

Hi All Sorry very new to VBA and cannot work out how to do this I have tried adjusting numerous codes and cannot seem to get this, what I perceive to be simple, issue sorted! No doubt it will be one of the simplest questions to answer! I have a drop down list in column I, what I want is...

Hello. I am struggling with what may be quite simple. I am working with timestamped data in dd-mmm-yyyy hh:mm:ss format, where a value occurs every 5 minutes (but not exactly). I require to obtain an hourly average for each and every hour, which would normally be an average of the previous 12...

Hello everyone! I am new to the forums and this is my first post so please be kind. My excel version is 2010. I have 3 operators using a barcode scanner to scan products coming into the factory. They stay in the factory for a period of time and then they are scanned out again. I require to...