Can someone help with a Date Stamp in excel.

I just need something to show "Updated Last" time for any time a cell is updated. I have to print this for my boss every once in awhile and would like that date to show. So if I did an update yesterday, but I printed it today, I need yesterday's date to show.

Thanks in advance for your help.

Charmed

You can use the worksheet Select_Change event. Open the attached file for an example. It will add a comment each time a cell is changed.

I checked that out. I need it to show in a cell vs a comment. I have to print the spreadsheet for my boss and would like him to know when the last it was updated. He hasn't quite grasped the concept of opening a spreadsheet yet.

:(

Thanks for the idea. I tried to play around with it so it wasn't making a comment but I'm just not familiar with VBA.

Any other suggestions would be awesome.

Charmed

So you want the date stamp in the column next to the cell update? I am confused which cell you want the date stamp in.

Can you tell I moved on to other projects? They are keeping me busy. Which is good I guess. Sorry I didn't get back to you.

What I want to do is put a date stamp in a cell. (Not as a comment) so when any part of the spread sheet is changed, the date will update to Now(). That way if he opens the spread sheet to print it, the last time I changed it will show the date.

Thanks a million for your help.

Charmed

He wants to know WHICH CELL ? or should he just pick one at random ?

No, he wants to know when any cell in the sheet has been changed/updated. I can't pinpoint a particular cell that will always change, it can be anything.

Charmed

No, he wants to know when any cell in the sheet has been changed/updated. I can't pinpoint a particular cell that will always change, it can be anything.
CharmedDo you always refer to yourself in the third person ?
KeithG wants to know where do you want the 'date stamp' to go ? or shoudl he just pick a cell at random ? HE knows how to access your sheet change event and when it gets fired for ANY change then he can write a new stamp to YOUR CELL, but which one ? or do you want it, as he puts it "the date stamp in the column next to the cell update" ???

Unmarkedhelicoptor is correct, I need to know where you want the date stamp.

Good Afternoon Everyone,

I have been searching for a solution to what I believe is fairly simple (for anyone that knows what they are doing ... which is not me :(). This discussion is very close to what I was looking for.

I have a workbook with multiple sheets. Each sheet is made of rows that are logs of open issues for a project. My boss has requested a column for "Last Updated". So that whenever any cell in a given row changes, the cell in column Z of that row is updated with the current time using =NOW() or something similar.

I figured out how to do it using Worksheet_Change however only for a single cell.. not ANY cell in ANY row and posting the date in the column Z of that specific row.

So if any VBA wizard could assist me I would be much obliged.

Thanks in advance for your wisdom! :)

-Drew

Ps. Sorry if I am hijacking this discussion, it seemed that the original question has fizzled.