| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet update date
I have a excel workbook with many sheets and in my master sheet i hv all the
sheet names in one column, i would like to have macro code ,so that if anybody type any comments on any sheets the date need to be appeared on my master sheet next to sheet name column. Example Master Sheet: sheetname sheet1 sheet2 if somebody open the excel file and update the comments on sheet2 and the file is saved and closed. when i look into my master file, the comments updated date should appear next to column of sheet names Master Sheet: sheetname comment Date sheet1 sheet2 May 27th 2009 11:15pm |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update date every two weeks when a sheet is opened | Excel Programming | |||
| Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
| Display a update date on a sheet for a shared excel workbook | Excel Worksheet Functions | |||
| How to update a cell if a specific date is included in a date rang | Setting up and Configuration of Excel | |||
| Date update on data update | Excel Programming | |||
![Ranjith Kurian[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
