Hi,

I have a single worksheet in a workbook that is populated by a single user
entering data in a userform that he/she calls up when required.

I want to create a copy of the worksheet and have it in a new workbook on
the network. When the original worksheet is updated I want to write the same
data to the new worksheet so that network users can just read it.

How do I get a userform to write to a workbook other than the one it is
created in ?

MAS