G
genegal
Good afternoon everyone,
Just as a basic introduction, My name is Gene, and I'm working at a company
producing a CRM database, which includes an Excel template file that I
provide the employees to fill in so that they may fill in the contact details
while away from the database and add them whenever possible.
I have my database currently linked to an Access database, so that on
start-up of the Excel file (I've saved both an XLSX and XLS format for
testing purposes) the excel spreadsheet will update any details (if changed)
for lists such as countries, employees and services (list of divisions of the
company).
I have no problem creating the data link between the two, and the the
'connections' settings and 'properties' are all set to how I would like them
to work.
The imported data for the countries, employees and services are all saved in
their own individual worksheet. Now, the idea is to have a drop-down list
(from Data Validation) to list the countries, employees and services as
stored in the independent worksheets. What I experienced with Excel is that
Excel can't use a data range which might change in size; it prefers to refer
to a fixed range (a fixed number of cells, a single column/row). So I had to
select the column where the data sits. I named each column with titles such
as "Country", "Service" and "Employee".
I used the Data Validation tool to locate each range, and the list works
perfectly. However, when I intended to use error checking for invalid data,
it doesn't work. If I enter in the wrong information, it passes the error
checking and doesn't register as invalid data. Now I have a problem of trying
to solve this problem.
Has anyone else experienced this? What is the solution?
Thanks for your help everyone,
Gene.
Just as a basic introduction, My name is Gene, and I'm working at a company
producing a CRM database, which includes an Excel template file that I
provide the employees to fill in so that they may fill in the contact details
while away from the database and add them whenever possible.
I have my database currently linked to an Access database, so that on
start-up of the Excel file (I've saved both an XLSX and XLS format for
testing purposes) the excel spreadsheet will update any details (if changed)
for lists such as countries, employees and services (list of divisions of the
company).
I have no problem creating the data link between the two, and the the
'connections' settings and 'properties' are all set to how I would like them
to work.
The imported data for the countries, employees and services are all saved in
their own individual worksheet. Now, the idea is to have a drop-down list
(from Data Validation) to list the countries, employees and services as
stored in the independent worksheets. What I experienced with Excel is that
Excel can't use a data range which might change in size; it prefers to refer
to a fixed range (a fixed number of cells, a single column/row). So I had to
select the column where the data sits. I named each column with titles such
as "Country", "Service" and "Employee".
I used the Data Validation tool to locate each range, and the list works
perfectly. However, when I intended to use error checking for invalid data,
it doesn't work. If I enter in the wrong information, it passes the error
checking and doesn't register as invalid data. Now I have a problem of trying
to solve this problem.
Has anyone else experienced this? What is the solution?
Thanks for your help everyone,
Gene.