Need help with a formula to show the date the sheet was last editted on.

[jennyjohanneck]

I have a spreadsheet that I use as a project planner. I update it throughout the week as projects start/finish. My co-workers look at the spreadsheet to see where projects are at in the process. I would like them to be able to see when I last edited the document. I thought I knew excel pretty well until I came here and noticed the vast amount of knowledge and I think I might be average. I found a post where someone talked about macros and scripts and I am not familiar with that at all.

I want the formula to look at edits in columns A-G and all rows.
I want the "last edit date" to return in G2.

Any help would be great!

[FDibbins]

Hi, welcome to the forum

This is not possible with refgular formulas, you would need VBA to do that. Let me know if this is an option you would consider?

[jennyjohanneck]

I definitely would, as long as you can walk me thru the process! Thank you for the welcome, I look forward to learning more!

[FDibbins]

My VBA is not that good, but this seems to work. It puts the date in B2
Adjust to where you want it

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[jennyjohanneck]

Ok I set it up today and will test it tomorrow. I want to make sure that it shows the date the workbook was last edited, not just opened.