Home » Forums » Open Source Learning Center » Question and Answer

[Solved} Creating a new sheet -

Submitted by ALNeto on 1 November, 2012 - 18:27

Hi i´m new on excel, so have a doubt. i would like to creat some sort of diary so when a create a new sheet, automatically this will have same content of the old one, but some cells must be updated, like the date and the new page. It´s possible to create somenthing like that? If yes how can i do it?

Since now my regards.

ALNeto

‹ If, Then Formula Search, Copy & Paste macro. ›
»

Update cells when new worksheet is created

Submitted by manny on 2 November, 2012 - 14:43.

Hi,

The short answer is: Yes, it is possible.

But you must be familiar with VBA.

You can use the Workbook_NewSheet event. For example:

Private Sub Workbook_NewSheet(ByVal Sh As Object)

    If TypeOf Sh Is Worksheet Then
        With Sh
            .Range("A1").Value = Now
        End With
    End If

End Sub

If you need additional help on this topic, please explain in more details your requirements. And will be better if you can attach an example file.

 

Best regards.

»