Excel worksheet updating macro
We have checked to make sure that the workbook and worksheet: 1. That not all the worksheets are selected There are only two worksheets in this workbook.Any ideas of why we are unable to make a copy of this worksheet within the same workbook or to another workbook?I need the cell to keep in the cell the date of the day when I filled in the content of cell C90 and do not updated it every time i open the document to the actual date.. I am trying to automatically capture and record the date of a cell's last change in value (date stamp).I have an item price list and if a particular cell gets updated I want to automatically record the date of change of that cell.
If you need more information about the parameter values, click the function name in the code editor, and then press F1 to display the corresponding help topic, which describes each parameter.I want to be able to just highlight the selected range of cells I need to insert into and hit a macro button and have the date and time inserted into just the cells I have highlighted.I'm not sure how to make this work with just the cells I've highlighted.Hello, I have a number of different files that I often need to run a macro on.
In order for me to do it on the 75-100 files I have at any given time, I need to open one, run the macro, close and save, then open the next one.
I don't want to post the whole macro as some of it is proprietary.