Hi, I am creating a macro that saves rating and comments in MS Access. I would like to know if it is possible to save fields in MS Access by it's existing columns. Below is how I have the MS Access Database set up:

Evaluator Name KPI1 KPI1 Comments KPI2 Comments KPI3 KPI3 Comments

This is how I want the algorithm to flow.

1. Evaluator (Entry on Excel) saves in first column (Evaluator field in Access)
2. Name saves in next existing column in Access.
3. KPI1 saves in next existing column in Access
...
If next column is the last column and no columns come after, process ends.

This way, I only need to create a single Macro and call it on every saving process I have.