How do I return the date that something on my workbook was most recently changed?

**Mogles** · 11-17-2015, 10:04 AM

Hi everyone,

I'm looking to add a formula that will tell me the most recent date that anything has been entered on my shared workbook. I'm looking on one tab only where data is entered, so the formula would only need to focus on this tab (or a range within this tab) - is this possible, and if so, how?

Thanks!

Mogles

**Obsessed** · 11-17-2015, 10:20 AM

You'd have to use a macro with a worksheet_change event, and for it to work, any user modifying the worksheet would have to have macros enabled.

How do I return the date that something on my workbook was most recently changed?

LinkBack

Thread Tools

Rate This Thread

Display

How do I return the date that something on my workbook was most recently changed?

Re: How do I return the date that something on my workbook was most recently changed?

Thread Information

Users Browsing this Thread

Similar Threads

copying data from a recently opened workbook to the workbook where the form is present

[SOLVED] has the "my posts" functionality changed recently??

[SOLVED] How to return the most recently passed date from array

[SOLVED] return date when current value most recently occured

[SOLVED] Return data from the most recently updated column

Date workbook changed

[SOLVED] need to ONLY display worksheets that have had recently changed

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions