Insert command for updating an excel spreadsheet risks of non sedating antihistamines
My ideal would be to only have the prompt display for me..I know that that is dream-land stuff. For instance, A B 1 .17 8/17/08 2 .20 9/12/09 If I go in and update cell A1 to .98 today I would like cell B1 to read 2/16/10. I've searched and searched and not come up with anything yet!!
This process takes 2 secs but some people forget and stay in it over lunch etc causing a great annoyance. Im not concerned if they lose any data they've entered as I'm sure this will help them get the message to get out the file quicker.. pls help Okay, so I tried (for hours) to find a solution to this and have finally gotten frustrated to the point where i think asking here will be my best bet.
After I update this document I ensure that it is read only. If anyone can help it would really cut down the time I spend collating these stats every day!
When my employees open up the document they receive the message: This workbook contains links to other data sources. I am trying to automatically capture and record the date of a cell's last change in value (date stamp).
Please provide me with any Formulas as micros are disable in my Computer..... Hi, I have the following code to put data from a VBA userform into Excel Dim Sh As Worksheet Dim Rng As Range Set Sh = Active Sheet Set Rng = Sh. I'm concerned that changes will get over-written when 2 people are saving their changes. I get the error message "reference is not valid" each time I open my spreadsheet.
There will be a varying number of rows in each of the individual sheets.
Search for insert command for updating an excel spreadsheet:
I have set up a spreadsheet which links to a heap of other spreadsheets. If possible I would like the macro to run every time data is entered into one of the individual worksheets.