Keep a history of a particular cell

[JJ11]

I think I will need VBA code to be able to do what I want if possible. I'll try my best to explain.

I would like to be able to keep a history of dates that were entered in another cell.

Column B is Next Date for Review so this will be updated manually every time that person has a new review date, I would like column F to keep a history of all dates that have been entered into column B.

I have attached a sample s/sheet, so the next review date is today, I will be updating this with a new date but I want column F to keep a record of todays review date along with any previous dates.

[nigelog]

Simple way

Please Login or Register  to view this content.

[JJ11]

Sorry I was not very clear, I want it to go into cell F2. So one cell contains all the previous dates for that person as each row is a record for one person and to apply to the whole column as there will be 50+ people.

If possible to work on a protected worksheet as well.

[KOKOSEK]

Do you want to keep these dates in col. F for on each row, right?

Please Login or Register  to view this content.

if, instead of new line for each date, you choose comma, change vbNewLine into ", ".

[JJ11]

Yes that's what I would like.

[nigelog]

If I understand

Please Login or Register  to view this content.