Keeping form data to one sheet

**Niall Harper** · 07-29-2010, 12:27 PM

Ive now finished my form however ive come accross one problem. The form data will be entered into what ever sheet im currently on. Which i dont want. Is it possible to be on one sheet whilst filling out the form and have the data go into another sheet?

Many thanks

**royUK** · 07-29-2010, 01:02 PM

Yes, just specify the sheet in the code. This will write A1 in Sheet1

Please Login or Register  to view this content.

**Niall Harper** · 07-30-2010, 05:22 AM

Thanks for the help Roy however i could not get the code to work.
Below, i have posted the code im using for my form. Would you be able to show me where i need to paste your code in please.

Many thanks

Please Login or Register  to view this content.

**royUK** · 07-30-2010, 05:59 AM

You've used the With statement, but not qualified the cells

Please Login or Register  to view this content.

**Niall Harper** · 07-30-2010, 06:55 AM

Thanks very much for your help. Been a great help!

**royUK** · 07-30-2010, 07:01 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save