Hi guys,
Ive taken over a project from someone else and although it works fine, it requires more work/time to update and maintain, than i have and as excel is capable of doing this work for me, it would a waste not to.
In a nut shell, its a way for users to record certain data and update this on the database (managers version, that tracks trends and such). the problem is that that, all this means is that the data gets sent to me via email (with excel attachment), for me to then manually update to the master sheet.
Im testing out using the macro im sure you're all aware of, that opens the master sheet to perform the update and then close the master sheet again.
This works fine, but i have a few questions.
1/ A few of the people ive asked to test it, are being asked to save the master copy, before it can proceed to perform the update??. Around 10 people have tested and this only happens for two people.
2/ There is a potential for multiple people to "press the button" at the same time, which will casue issues. it seems to work Fine when two people use it simultaniously, but it doesnt like three at once. The error was along the lines of it being in use and to try again later.
Its not absolutely imperative that 100% of the users entries are completed, so it wouldnt be the end of the world, if, when this happens, excel just ignores the later of the entry attempts and moves on without error.
Any ideas