MS Excell ( Auto Formula)?

Question

i wanna know if it would be possible to have a formula in Ms excell that would automatically indicate the date & time of the info entered in any of its cell E.g Collum A: is the collum wherin the the date and time should be entered when any information in Collum B is added whether be it Num/Alpha.... i have been tryin using IF {(=IF(F14,(TODAY()))} but i get the current systym date when i open the File .. I wanna have the date only when the Info in Coll B is entered.
In short i wanna know the date & time of entry of the Particulars that is entered in the excell sheet ..

Answer 1

The first responder is correct. You can't do it with formulas. Fortunately, you can do it with macros and the macro is extremely simple for your case.

When in Excel, use Alt+F11 to get to the macro editor. When you see your workbook listed, double-click the "ThisWorkbook" icon and paste in the code below:

Private Sub Workbook_SheetChange (ByVal Sh As Object, ByVal Target As Range)
If Target.Column = 2 Then
Target.Offset(0, -1).Value = Now()
End If
End Sub

What the code does is check any time any value is changed in the workbook. In my example, if any value changes in the second column (the "B" column) then it gets the column to the left (the "A" column) and writes out the current date/time as a value so that it "sticks" and won't change everytime you open/close/recalculate the workbook.

Answer 2

You can't do that with formulas alone - you will need to write a macro. Formulas only support data manipulation within the scope of the spreadsheet session - not committing data to the file.

Answer 3

80 5> ? 80 5 is larger than distinction 80 5< ? 80 5 is below genuine high quality & 60> ? 60 is larger than genuine high quality 60< ? 60 is below second classification & 50> ? 50 is larger than second classification 40 5> ? 40 5 is larger than pass classification & 50< ? 50 is below pass classification -=- you're an fool. not one of the above expressions make experience.