Auto Time Stamp

[JayPky]

Hello,

I am trying to type a Auto Time Stamp formula in a Cell and having problems.

For Example:
Cell E2: Location for Auto Time Stamp
If C2 (Progress) is Done, set autodate and time into E2, if "Blank" or "In Progress". Leave Blank.

I keep reading forums and I see macros not formulas, so I am getting confused.

v/r

[dogberry]

Hi

Can you post a sample worksheet so we can see the layout etc dont post confidentail information


To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.



Chris

[JayPky]

Here you go. Thank you for help.

[dredwolf]

The reason you see macros and not formulas is because the time stamp will change every time the workbook/worksheet recalculates if you use formulas...the macros will change the cell contents and leave it alone, UNTIL you run the macro on that cell again...one way around the formula issue is to use the say NOW() or TODAY() functions, then copy> paste special >values back into the same cell, but that can become VERY tedious

[Fotis1991]

In fact we can do this using formulas.

In E2 and copy down.

=IF(OR(C2="",C2="In Progress"),"",IF(AND(E2="",C2="Done"),NOW(),E2))

This will gives a circular reference.

So

1. Go to Tools  Options  Calculation Tab  Check the Iteration checkbox.
Maximum iterations,Must be 1.Not 100!.