Ajit,

Number of users: 5
Amount of Data: we have about 500 records now
# of fields for each record: 27

There are 2 tabs in the spreadsheet, A and B. B holds
all the data. I have created A as a "template" where
user can input data for each record. A can also be used
to update a field of each record. Hope the information
helps.

Thanks
-----Original Message-----
There could be couple of ways to achieve this but i
could not gather enough information from your question.
Write some details and i dont think it is gonna be tough.

Also answer some questions like : Number of users,
Amount of data. Any report printing from that data , How
many fields for a particular record etc.
.