Colleen45
Active Member
- Joined
- Jul 22, 2007
- Messages
- 495
I would like to have the date inserted ( b1) whenever the value in cell a1 exceeds 0, the date must not change when i open the workbook a few days later.
I am using this in a Library situation, where excel needs to remember the date the book was issued. thus I need to apply this to the entire column.for each item that gets loaned out. (and obviously remove the date when the value goes back to 0
I realize that some VBA code is required, as there is no worksheet function.
As a second part to this question, could i use the same code in a second private sub statement on the same worksheet.
This time when ever the value in cell c1 (for example) exceeds 0 (new card no) it needs to insert the date in d1 (date joining) and again not change when the workbook is reopened (again i need to apply it to the entire column)
sorry for the long explanation
I am using this in a Library situation, where excel needs to remember the date the book was issued. thus I need to apply this to the entire column.for each item that gets loaned out. (and obviously remove the date when the value goes back to 0
I realize that some VBA code is required, as there is no worksheet function.
As a second part to this question, could i use the same code in a second private sub statement on the same worksheet.
This time when ever the value in cell c1 (for example) exceeds 0 (new card no) it needs to insert the date in d1 (date joining) and again not change when the workbook is reopened (again i need to apply it to the entire column)
sorry for the long explanation