date stamp

Hello, Working on creating a long checklist. When Form Control Box is checked "completion Date & Time" is seen next to the task. The issue seems to be every time any value is checked ALL of the time/date stamps update. Please see below: Column B Check Box (Form Control) Cell Linked: $G$9...

Hello, I am a beginner at VBA, I know enough to get myself stuck frequently. I am trying to write a VBA script, for archiving purposes, to write a copy of file and add a timestamp in this format (mm_dd_yyy) and place the copied file in a specific folder. The location folder path is...

I have a code built that, upon clicking a command button, displays an email to a coworker when a cell in column P is "X". When a cell in column P is updated a date stamp is automatically entered into the adjacent cell in column Q. How do I update my code so the email displays only if the...

I have a spreadsheet with 3 columns; A:product, B:price, C:date where from time to time I update the prices and I type in the date the price changed in the last column. I want to automate the date stamping. However, I only want the date to be updated when the value in column B (price) is...

Hi, can anyone help me with a formula or VBA code to create a cumulative running total of loyalty points earned and Date stamped, which are valid for 1 year? Then when points are spent at a future date, the spent points are then allocated to the first Date stamped points in the table until the...

Hi there, I currently have a drop down list which requires an individuals unique password to change it. Once a name is selected/the correct password is entered, I would like an initial and date stamp to be applied to the cell to the right of the drop down list. This stamp should only change...

Hi there, Can someone help me write this VBA code please? In column K (from K9 down) I have dates or blanks. I want to be able to push a button (POST) and if column K has a date in it (ie. isn't blank) then today's date should be entered in column L (L9 down). Once this date is entered in...

vba codes for automatically date appear in a cell of whatever sheet i want. whenever i open workbook

For now i have 2 spots that have a time stamp when text is entered/changed C19 changes text C20 is date stamp, same with C30 and C31 getting date stamp. C19 pulls its cell value from another place and updates (to the same value) every time the document is opened so i don't want that to change...

Hello All! I am working on some macros, one i have is triggered when a capital "X" is entered into any cell in a particular column, it then adds the current date right next to it. I had help writing this code, however, I want to alter the macro so that when something populates column "A:A" that...

Hello all! I am working on trying to understand how to use this macro I found, the macro places a "MM/DD/YYYY" time stamp in my sheet in column "V" when a value is entered in column "u". What i need is for this to hold true for the dates in columns "X" and "Z" when columns "W" and "Y"...

Hey any help would be highly appreciated as a control feature i would like to know when a set of data was last updated. My data is as followers for the columns A,B & C <tbody> A B C 1 Company X 2 3 Header Value Date 4 Name1 x 31/06/2015 5 Name2 y 31/06/2015 6 Name3 z...

Hi, I have the macro below to put a date stamp in a cell ("U") when the text in another cell ("I") is changed. This works fine. However the original cell "I" automatically populates with "open" when a new row is created within the spreadsheet and A date stamp is created at this point. Therefore...

Greetings, I'm using a Surface RT, therefore, I can't use VBA. I'm trying to put a 'Date' and 'Time' Stamp into two cells when data is added. But I check the time cell and do a difference between the time before. The cell for date, =IF(K8<>"",IF(H8="",NOW(),H8),"") DATESTAMP...

Hello, I have looked everywhere I feel like for a solution to my problem. I have never worked with VBA before, and am having trouble finding a solution for my problem. I have a range of cells, "D:F", in which I need a time stamp to be placed in column "I" on the event of any of the formula...

Hi, I am not sure if this is possible, but I would like to create passwords for specific Excel users. Basically I have a list of about 10 people, that need to be able to electroncially sign-off Excel documents. Only these people will be able to edit a worksheet, anyone else would have read...

I wrote a date/time stamp macro to auto update in a single, specified cell every time data is changed or entered in any other cell for specific worksheets in a workbook that have various other macros and functions. The code works perfectly when the sheets are NOT protected; however, it no longer...

Hello all, I have just joined this forum because I have found the Danny Rocks videos on Youtube invaluable. I have looked high and low but haven’t been able to find a solution to this particular scenario anywhere on the Web. I thank you in advance for any assistance. Thanks to Bill Jelen I...

Good morning, I am working on a large database in excel that requires the current date when the word "cleared" or "denied" appears near the end of the worksheet in column AX using this formula. =IF(OR($AX15="cleared",$AX15="denied"),PERSONAL.XLSB!StaticDate(),"") I've stored this marco in...

Hi, I would like to date stamp a range of cells in column H, when the value on the same row in column G is changed to = "Yes". Have created a Worksheet_Change, but am unable to fix the column H change part. Private Sub Worksheet_Change(ByVal Target As Range) With Range("G34:G310") For...