Multiple users with single form and central data base using VBA for Excel

[NKOTB_VBA]

Hello All, I am new to VBA and recently went through some startup training. I was browsing the web for some help on my questions and came across this forum, and I must say this is an awesome place to enhance and polish your skills.
Here is what I am trying to solve and need expert guidance - I have a team of auditors and was wondering if it was possible to create, using VBA, an interface where each auditor uses a form for data entry and the data is captured in a single common excel file placed on a server. The idea is to pickup 70% data from excel, perform the audit and input the remining 30%, ensuring when simultaneous inputs are made, we dont have data overwriting.......Thanks in advance and please excuse if this is not the right way of explaining the problem as this is my forst note

[royUK]

Excel is not good for multi-users. You will get problems when other 2 or more attempt saving, etc. In this case Access might be a better option

[NKOTB_VBA]

Thanks Roy for the quick response; I'm not sure if the VBA basic programming skills can be used with Access but can we create the macro in excel with Access as the database or would this require complete working in Access?

[royUK]

You can have Excel as a Front End for Access, do some searching through the Forum, or post in the Access Forum here

[NKOTB_VBA]

Thanks Roy; I will do as suggested.