Hello! I have been given the task of creating a shared workbook to be used at
30 locations around the country. There will be one user at each location
using the workbook. I have the workbook desigend, heavy with validation,
tips to enter their data etc to make it as foolproof as possible. My only
concern is that as users are entering records how can I prevent them from
entering records on the same line at the same time??? Is there some type of
a form I can develop using VBA perhaps where the data will be gathered and
they perhpas click a command button and it will put it on the next available
line??? I am totally stuck here. Any thoughts on this would be greatly
appreciated!!! :)

Have you tested this to see if users currently can enter data in the same
cell at the same time?

Before you try to create a form to address this issue, I would test to see
if it is an issue.
--
Brevity is the soul of wit.


"Rich In Pgh" wrote:

Hello! I have been given the task of creating a shared workbook to be used at
30 locations around the country. There will be one user at each location
using the workbook. I have the workbook desigend, heavy with validation,
tips to enter their data etc to make it as foolproof as possible. My only
concern is that as users are entering records how can I prevent them from
entering records on the same line at the same time??? Is there some type of
a form I can develop using VBA perhaps where the data will be gathered and
they perhpas click a command button and it will put it on the next available
line??? I am totally stuck here. Any thoughts on this would be greatly
appreciated!!! :)