Fawn Marie
06-10-2015, 09:39 AM
I have a "Master" file with many sheets for each production week. I am trying to copy from the sheet of raw data file to the "master" file. For example "raw data" workbook is called "May 3-9" and sheet in the workbook is called "May 3-9". The below code works fine for copying it but it creates a new sheet. I would like it to insert the into a current sheet (May 3-9) of Master. I also want it to update once the raw data file is updated (closed file). I am VERY new to VBA and I am not thinking that I will ever figure this out.
Sub Importsheet()
Dim Importsheet As Worksheet
Sheets.Add Type:= "C:\Users\Fawn\SkyDrive\External Hardware\NDT\Reports\OMA Agent Performance Management\Ready 2015\May 3-9.xls"
End Sub
Sub Importsheet()
Dim Importsheet As Worksheet
Sheets.Add Type:= "C:\Users\Fawn\SkyDrive\External Hardware\NDT\Reports\OMA Agent Performance Management\Ready 2015\May 3-9.xls"
End Sub