How to save meeting dates permanently with Excel?

[gravanoc]

Someone wants the meeting dates they have held to be recorded and to be retrievable. This kind of makes me think a proper database is required, but maybe someone has a reasonable format where this can work. The workbook has already been setup to save the dates for a particular job number, but if anything new is placed in the cell on the user's sheet, then that date will overwrite the old date.

The user sheet is called Job Planning. The user presses the Job Form button & a user form pops up where they can enter the job number, job name, project manager, etc. Then in the D column they enter the meeting dates. They can save these dates on the Job Form as well.

The problem is that I can't think of a way to save the dates long-term without getting extremely elaborate with VBA or using a single sheet for each job number. Any ideas?

Here is a link to the sheet, it has VBA in it: https://drive.google.com/open?id=1-LrFaPEPuOwBD_iGSP9mwz49cf9Qis7q

 

[Fazza]

hi, I can't look at the posted file from where I am now, however from the description, what about writing to a TXT file? It is simple VBA & Google will find many online examples. HTH