I am working on a tracking spreadsheet, The Macro I have to take the data from a slave spreadsheet and present it into a master works great, except it is pasting links instead of values. I have run against a wall and cannot get it to work properly. Any help would be wonderful. Here is what I have
Sub WriteToMasterList_v2()
Dim curName As String
Dim nxtRw As Integer
curName = ActiveWorkbook.Name
'Open Master Workshop List.xls (Hidden if saved Hidden)
Workbooks.Open Filename:="C:\Documents and Settings\64h9978\my documents\excel\master workshop list.xls"
'Determine next empty row in master workshop list.xls
nxtRw = Workbooks("master workshop list.xls").Sheets(1).Range("A" & Rows.Count).End(xlUp).Row + 2
'Copy Activeworkbook row to to log.xls
Workbooks(curName).Sheets(3).Rows("1:8").Copy _
Destination:=Workbooks("Master Workshop List.xls").Sheets(1).Rows(nxtRw)
Application.CutCopyMode = False
'Save and close log.xls
Workbooks("Master Workshop List.xls").Save
Bookmarks