Hi,
Can we assume that in the actual RotaData workbook some of the cells are formulae, since otherwise you could of course just save the whole file as the Viewer workbook since you say the Viewer wb should not contain formulae.
Why not just use a macro which copies the RotaData active sheet and in the new resultant Viwer file converts all formulas to values? i.e. something along the lines of:
Sub CopySheet()
ActiveSheet.Copy
Range(Range("A1"), Range("A1").SpecialCells(xlCellTypeLastCell)).Copy
ActiveSheet.Range("A1").PasteSpecial (xlPasteValues)
Application.CutCopyMode = False
End Sub
Bookmarks