Copying data entered into a form to another workbook

Z

zak

Hi

I'd like to know if it is possible to do the following:

1) I have created a form, but as well as wanting the form to copy the data
into a worksheet within the workbook the form was created in, I would like
the same information to be copied into a different workbook at the same time.
Is this possible?

i.e. the form prompts for name, date and time. I would like this info to be
copied into a worksheet in cell ref a4,b4,c4 respectively, BUT also into a
different workbook in cell ref a4,b4 and c4.

Thanking you in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top