what do i need to do to keep the master workbook to keep the formulas?
wbMaster.Worksheets("sheet1").UsedRange.Copy After:=wbLocal.Worksheets(wbLocal.Worksheets.Count)
wbMaster.Worksheets("sheet2").UsedRange.Copy After:=wbLocal.Worksheets(wbLocal.Worksheets.Count)
wbMaster.Worksheets("sheet3").UsedRange.Copy After:=wbLocal.Worksheets(wbLocal.Worksheets.Count)
wbMaster.Worksheets("sheet4").UsedRange.Copy After:=wbLocal.Worksheets(wbLocal.Worksheets.Count)
any help will be greatly appreciated.
managed to adapt the formula from another sheet works fine example:
With wbMaster.Worksheets("sheet1")
.UsedRange.Value = .UsedRange.Value
.Copy After:=wbLocal.Worksheets(wbLocal.Worksheets.Count)
End With
Last edited: