I have very limited knowledge/experience with Excel. I have been asked to incorporate Excel into a Access application i have developed.

As part of the Access application the spread sheets are being updated from forms.

My question is, i have spread sheets with three different sections on one sheet. A Completed section, a production, and a "Waiting" section.


Is it possible that if a change is made to the status of an object.

For example if something is changed from Waiting to completed, can i program Excel to move that Row From the Waiting section to the completed section automaticly for my users?