I created a database (table) in excel in one spreadsheet. I then created four other input spreadsheets that my employees enter data and then use vba code to look up the correct row in the table and either update the data or create a whole new row. It looks like if more than one employee accesses the same input spreadsheet at the same time the program requires one to save the changes to another file, which I don't like.
Is there a way to limit access to the input spreadsheet so if one user has it open another can't see it or can't edit it? Should I have created this workbook in Access instead of Excel?
Below, CLIENT DB is the database (Table1), the other four spreadsheets are just forms filled out and then copied to the database as needed.
Is there a way to limit access to the input spreadsheet so if one user has it open another can't see it or can't edit it? Should I have created this workbook in Access instead of Excel?
Below, CLIENT DB is the database (Table1), the other four spreadsheets are just forms filled out and then copied to the database as needed.
