Excel Form data to closed workbook
 

Hi,

I've tried looking for an answer to this and have already asked
another group both without success. Q. Can user input data be
collected in a form in one workbook and sent to a closed workbook.
Colleagues have been able to delete/change data and they have even
deleted the worksheet altogether. To help solve this I would like to
have this information backed up within a seperate location, which if
this can be done will have a side affect of providing an overview of
the whole data group. Ideally this would be a form which sent data to
an internal and external worksheet at same time.

Many thanks in anticipation

Don