Date Last Modified

**Austin Zeagman** · 07-12-2010, 01:32 PM

I have an excel database where i would like the have the last column in every row print the date that any of the info in that row was modified. The reason i want to do this is so that i can later call on all the item that have been modified between two certain dates, and any such items will pop up in a list. Any help is appreciated.
Thanks

**royUK** · 07-12-2010, 01:57 PM

Try this UDF,place it in a standard module

Please Login or Register  to view this content.

**Austin Zeagman** · 07-13-2010, 09:06 AM

That is almost what i am looking for, however i need the date to appear in a cell at the end of each row of data, and the date should only update if that particular row was modified, no if the workbook/worksheet is modified. Thanks again

**royUK** · 07-13-2010, 09:23 AM

Which Column needs to hold the datae?

**Austin Zeagman** · 07-13-2010, 09:29 AM

Column BH, and it would be on a couple different worksheets

**Austin Zeagman** · 07-13-2010, 09:58 AM

If more information is required please just let me know.

**royUK** · 07-13-2010, 01:53 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!