I’m try to create a excel template which will have three fields I like to update automatically when it’s open.
Fields which this template will have
- Current Date: 02/07/2012
- Sheet Number: 25
- Between Date: 02/07/2012 to 02/08/2012
When I open this template after 03/08/2012 this sheet will have new data
- Current Date: 03/08/2012
- Sheet Number: 26
- Between Date: 03/08/2012 to 02/09/2012
For current date
Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Sheet1").Range("A1").Value = Date
End Sub
Can this be done using excel function or do I need to use VB and also how do I update template automatically with new values to say next time use these dates.
No comments:
Post a Comment