Hi all.
Question 1:
I have an Excel Workbook that I use to record Health Assessments for a number of different companies, listed in a separate sheet in the same workbook. For each company, I then have quite a big number of employees. These are listed in a separate Excel file (all employees of all companies). This is quite a large file, growing on a daily basis.
What I wish to do is, from a selection box on my "front page" (already set up and working), select the company that I need. Then I wish to import employees specific to that company (ONLY) into a table in the first Workbook. Every time I choose a different company, that selected company's employees should then be imported into the table, removing the previous employees' list.
Up till now, I had this working by keeping the Employees file separate and calling data from that table, but some performance issues are starting to creep in with the ever-increasing size of the database.
Question 2:
If some data were to change in this (imported) table (e.g. a new employee is added, or an employee's address details changed), is there a way to add / change the data back to the "Employees" table?
If there are anyone that could point me in the right direction for doing these, it will be very much appreciated.
Kind regards
Chris.
Question 1:
I have an Excel Workbook that I use to record Health Assessments for a number of different companies, listed in a separate sheet in the same workbook. For each company, I then have quite a big number of employees. These are listed in a separate Excel file (all employees of all companies). This is quite a large file, growing on a daily basis.
What I wish to do is, from a selection box on my "front page" (already set up and working), select the company that I need. Then I wish to import employees specific to that company (ONLY) into a table in the first Workbook. Every time I choose a different company, that selected company's employees should then be imported into the table, removing the previous employees' list.
Up till now, I had this working by keeping the Employees file separate and calling data from that table, but some performance issues are starting to creep in with the ever-increasing size of the database.
Question 2:
If some data were to change in this (imported) table (e.g. a new employee is added, or an employee's address details changed), is there a way to add / change the data back to the "Employees" table?
If there are anyone that could point me in the right direction for doing these, it will be very much appreciated.
Kind regards
Chris.
