How to update row in gridview?

Row update

• I need to keep track of the latest data on a shared spreadsheet, so I'm looking for a formula or vba that will add the current date when data in the row is updated. I have information from B to U down and would like the date to be populated in the cells in column V. Any ideas? Does such a function exist? Kind Stuart

• Answer:

  I never recommend shared workbooks as they will get corrupted, and I'm not sure that you will be able to achieve what you want here anyway - you WILL need to unshare the sheet to add a macro, and you can use the change event of the workbook to set a value - the issue would be if more than one person tries to make a change to the data (even if it is different columns in that data) the update date will be the date used by the last person to save the file. I would STRONGLY recommend converting to an Access database as that IS mutli-user and won't corrupt in the same way that a shared workbook will. email if it helps - [email protected] - which will allow any follow up questions to include attachments!