1. S

    Time/Date Stamp based on Boolean Value, Formula only.

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

    VBA SaveCopyAs CSV

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

    Outlook attachment & Message box via Excel VBA

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

    Static datestamp by formula?

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

    Copy range to new sheet with date stamp

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

    An updating date that doesn't change previous dates

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

    Timestamp Help

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

    Date Stamp: recording date stamp in targeted cells when another cells is changed

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

    Date Stamp with IfStament

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

    Forcing input by user when cells are changed

    Hi team, I have posted this same query at a few days ago, but unfortunately there have been no replies. I am ultimately trying to achieve a track changes with commentary by the...
  11. R

    VBA give datestamp with worksheet change event/if statement?

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back