Dear all,
I have an access database where i keep track of various tasks of a project and i need to give an excel sheet to few people where they can have rights to modify the status of the task from open to in progress to complete and also input the completion date.
I would need a VBA macro to update the access database that I am having.
sometimes, they can add an entire task altogether (in a different sheet) and need a code where that gets appended to the task table in the access database.
Can someone please help me with a code for that.
Regards,
Gowri Shankar S
I have an access database where i keep track of various tasks of a project and i need to give an excel sheet to few people where they can have rights to modify the status of the task from open to in progress to complete and also input the completion date.
I would need a VBA macro to update the access database that I am having.
sometimes, they can add an entire task altogether (in a different sheet) and need a code where that gets appended to the task table in the access database.
Can someone please help me with a code for that.
Regards,
Gowri Shankar S
