Please let me know the feasibility of doing this. I hope you are good in MS Access. The requirements as follows.
We have 26 sheets (23 Input sheets and 3 dashboards) that need to be interlinked.
We tried linking through a Master database file but it's taking very long time for macro to update the master after each file is updated
Create Access database with each table (sheets) linked by product ID and link each sheets to the appropriate tables in Access. I think this way access tables and excel sheets are updated in real time
So when you open the excel you it should fetch data from its access table in the mapped Access DB. And any change made in excel should be updated in the same table in the same Access DB.
And the access tables should be inter liked with unique Ids, so if one table is updated with the change made in its excel then all tables which are linked should be automatically updated. so when we open the excel file mapped to that table, the updated data should be obtained.
Please not the following.
Don't take long time for files to open/close/update
Allow multiple users using the files (at any point only one user will use the sheets but users can use different sheets at the same time. for example Malaysia Medical can be used while Malaysia Regulatory is used)
16 freelancers are bidding on average $231 for this job
I am experienced in all Office programs and VBA. Currently I am giving MIS lectures at a university where I am teaching how to collaborate Office programs effectively, especially Excel and Access.