We have about 15-20 people working on projects that require entering data into a spreadsheet and then compiling the data from those sheets into a single sheet. Using Excel 2007 or Access 2007, I would like to create a form interface where the users can simply enter the data they need and have it sent to the next available row on the spreadsheet. I'm not sure how to accomplish this, so I'll need some guidance. Having people share and edit the same spreadsheet is not working for us because someone always manages to leave the sheet open so nobody else can edit. I also worry about having multiple users allowed to edit a single sheet in the likely event that they need to remedy a conflict between two people entering data in the same cell.
Start Free Trial
