datestamp

Hi Folks, I have a table with upwards of 1000 entries on it and multiple people will be working off this file (not at once). The idea is simple, you check a check box and it adds a time stamp into the "Sent Date" column. Each box is linked to the neighboring cell. However using the NOW() or...

I have the following code to which I am trying to SaveAs a copy in a drive as a CSV copy. However, I want to keep the original open as a master template. Basically how do I create a copy and THEN save that copy as a CSV file? When I run the below code, the macro falls down at...

Good evening, I have the following VBA code which opens up from Excel, an outlook outgoing mail and attaches a specific excel attachment located in the S drive. How can I incorporate a message box (in the below code) to notify if the attachment cannot be found in the location? Many thanks...

Hi all, I'm trying to enter a datestamp from a single cell entry point, and this works fine, but obviously it changes every time $A$2 is changed. (There are hundreds of entries in column "D") =IF(AND($A$2=D2,$A$2<>""),IF(E2="",NOW(),E2),"") I need the datestamp to remain static, after new data...

Hey all, As i don't know much about VBA i hope i can explain what i need to you guys. I have a workbook with daily results. Now i need to copy these results daily using a button into another sheet. Lets say Sheet Calculation range A31:E31 into Sheet HistoricalData range, new row, while adding...

Hi there, I am trying to create a document where new field entries will be added everyday with differing amounts of new entries each day as it depends how many calls we receive from customers that we need to log. What I ideally would like is for today's date to automatically appear on a new...

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

I ran into a problem in excel. I was hopingyou can help me. I have this code to enter a timestamp on a cell whenever Iupdate another and its working, but I also want to record a date stamp when Ichange data on another column other than column A. Like if I edit anythingin column C then date...

I would like to put a Date Stamp in G:G IF A:A or B:B = 1 Bellow is what I have so far.... Thank You greatly in advance... Private Sub Worksheet_Change(ByVal Target As Range) Dim Cell As Range For Each Cell In Target With Cell If .Column = Range("A:a").Column Then Cells(.Row, "F").Value...

Hi team, I have posted this same query at http://www.excelforum.com/excel-programming/780925-forcing-input-by-user-when-cells-are-changed.html#post2548789 a few days ago, but unfortunately there have been no replies. I am ultimately trying to achieve a track changes with commentary by the...

Hi all, I cannot get the proper VBA for the following: I want to get a timestamp date when a milestone is reached. Example: <TABLE style="WIDTH: 388pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=516><COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset...