daleyman gave me this formula
Private Sub Workbook_sheetActivate(ByVal Sh As Object)
Sh.Range("ba37")=Sheets("source_sheet_name").Range("ba41")
End Sub
I can`t get the xxxx thing to work for me, what I`m trying to do is get my total number cell (ba41) to go to the subtotal cell (ba37) when I create a new sheet, and to do the same thing each day I made a new sheet. Thankx.
This message was edited by rdrum on 2002-03-30 07:28
Private Sub Workbook_sheetActivate(ByVal Sh As Object)
Sh.Range("ba37")=Sheets("source_sheet_name").Range("ba41")
End Sub
I can`t get the xxxx thing to work for me, what I`m trying to do is get my total number cell (ba41) to go to the subtotal cell (ba37) when I create a new sheet, and to do the same thing each day I made a new sheet. Thankx.
This message was edited by rdrum on 2002-03-30 07:28