How to get the "Last Modified" date of a particular row which already has data in it?

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.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Did you read Ford's post #2?

You need to start there.

Yes it has been quite a while, and we are still waiting for your sample file to help us help you

I have a VBA to record the date from now on that i make changes to the column B, but i want the "past dates" when the cells which already have data were modified. Is there any way to do it?

Probably not. You're only going to have a record of changes from the point where you started tracking them.

See post #6. If you didn't put dates in when you made changes, then you won't have a record of them.

You're welcome. Thanks for the rep.



Sorry it's probably not the answer you were hoping for.