M
Mikeice
What I am trying to do is based on a cell in the MENU sheet B25
I want the blue hightlight in the cell to become the same.
Eg. IF B
B25 is July then the worksheet name will become July.
Is that possible?
Please help
Private Sub CommandButton7_Click()
Dim wbk As Workbook
Dim wks As Worksheet
Dim SrcBook As Workbook
Set SrcBook = ActiveWorkbook
Set wbk = Workbooks.Open("K:\Data.xls")
Set wks = wbk.Sheets("Sheet1")
Application.ScreenUpdating = False
SrcBook.Sheets("Transfer").UsedRange.Copy Destination:= _
wks.Range("B2")
wbk.Close (False)
Application.ScreenUpdating = True
End Su
I want the blue hightlight in the cell to become the same.
Eg. IF B
B25 is July then the worksheet name will become July.
Is that possible?
Please help
Private Sub CommandButton7_Click()
Dim wbk As Workbook
Dim wks As Worksheet
Dim SrcBook As Workbook
Set SrcBook = ActiveWorkbook
Set wbk = Workbooks.Open("K:\Data.xls")
Set wks = wbk.Sheets("Sheet1")
Application.ScreenUpdating = False
SrcBook.Sheets("Transfer").UsedRange.Copy Destination:= _
wks.Range("B2")
wbk.Close (False)
Application.ScreenUpdating = True
End Su