Hi Jim

Try this

You can use SaveCopyAs
Copy this in the Thisworkbook module to save the file also in C:\ (change that)

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
ThisWorkbook.SaveCopyAs "C:\" & ThisWorkbook.Name
End Sub

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jim" wrote in message ...
Hello. I would like to create two spreadsheets that are exactly the same in
two different places. Essentially, I would like to use a spreadsheet on my
local drive that updates a spreadsheet on a network drive that is accessible
to other people. This way when I save to my local spreadsheet it
automatically updates to the network document. Can this be done and how?
Thanks.