Excel cell change triggers database update
Posted on 2011-09-27
I have a spreadsheet with about 1,000 rows in it—essentially it’s all appointment information (dates/times, appointment #, etc.)
We need to trigger an update to a database table if certain cells within a column on this spreadsheet have changed. Only if a change is made to the cells would the database
Can you please show me the vba syntax to accomplish this?
Thank you for your help and time.