How to transfer data from User-form to multiple worksheet

[aliminate]

I need to create a user-form that will send data to different worksheet. enclosed an example of the worksheet. need some help. Thanks

[torachan]

Before setting up the form is the data any more complex than the simplistic sending of the number '1' to the relevant date column of the appropriate sheet and are the references really all the same irrespective of animal type. ????

[aliminate]

Thank You Torachan for the quick response, sending of the number '1' to the relevant date column and the Row of the appropriate sheet and the references really all the same regardless of animal type. Thanks again

[aliminate]

Torachan
So basically if we see an animal on the camera EXAMPLE R100, send 1 to the relevant date column of the appropriate sheet.

aliminate

[torachan]

see if the attached is useful - the Sheet "FrontEnd" must stay 'as is' because it is referenced in the code.

[aliminate]

Thank you so much for your help, it's working great. Is it possible to have Show form as a tab instead of front end. Thanks again

aliminate

[aliminate]

Is it possible to add more animals and cameras to the form dropdown

aliminate

[torachan]

Providing your extra sheets (animals) format is a duplicate of the (Deer) sheet and you do not use Sheet1 to record then the code dynamically expands to accommodate extra sheets.
As you have not given your location (locale) in your profile I cannot guarantee date format (this is country dependant (format and separators)) - all that is needed is e.g. (Europe, UK, USA .....).

[aliminate]

Thank you yes i am in Florida USA, it looks good. Thanks again

aliminate

[aliminate]

Torachan
Thank you for your help, the form works fine till we added some columns to the worksheet especially the dropdown, i enclosed example of the changes. Thanks again

aliminate

[torachan]

You can not just add unrelated columns and displace rows at will without altering your code reference datums.
The original used column 'A' and row 1 as references you have moved both therefore nothing will work.
You need to finalise your layout before attempting to code.

[aliminate]

I know and i am sorry for that but this is the final layout i am sure of it.
and is it possible this has nothing to do with the layout, after you hit submit clear the 3 dropdowns. Thanks again

aliminate

[torachan]

try the attached.

[aliminate]

Thank you so much for your help, i'll try it and let you know. Thanks again for your help much appreciated.

aliminate