Creating own data entry form

[Jennster]

Hi!

I was wondering whether it is possible to create your own data entry form to input?
I am aware that you can input via the menu... Data > Form... However I am hoping to achieve something that is a lot more user friendly. For instance, the users might not be aware of the shortcut to the form.

I am also going to have multiple worksheets in which I want the data entry form to update them all at once, oppossed to having to update each one individually. The worksheets will contain the same data however the column order will differ.

Is this something that is possible? I'm a bit of a novice with excel!

I'd appreciate any pointers.



I have asked the same question here: http://www.mrexcel.com/forum/showthr...ata-Entry-Form

[Pepe Le Mokko]

You can start here Why do you need multiple sheets ? Always makes things more difficult later ( see the zillion of posts on the forum)

[Kyle123]

Please don't crosspost, or if you do, let us know

http://www.mrexcel.com/forum/showthr...ata-Entry-Form

[Cutter]

Thanks Kyle

Hello Jennster, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

[Jennster]

Oh, my apologies! I have edited the post to include the post I've posted on another forum. I will do the same for any other posts now. Sorry again, I'm new to all this forum thing! Thank you very much for all your help!

[Cutter]

Perfect! Thanks.