indupriya9
Programmer
I have to perform two tasks in excel.
First task: I have to retrieve the values of two fields (issues and comments) based on a combination of two other fields (title and month) from a table. This table has these 4 fields.
Second task: I have to make the above two fields (issues and comments) editable so that when they edit and save the data they enter into these fields in the database. So that they can access the data they enter next time when they open the spreadsheet.
I am a newbie to VBA in excel. Is this possible to do in VBA. If so, can you provide some sample code for me to use or some documentation that I can read and try to do this.
Any help is appreciated.
Thanks
ip
First task: I have to retrieve the values of two fields (issues and comments) based on a combination of two other fields (title and month) from a table. This table has these 4 fields.
Second task: I have to make the above two fields (issues and comments) editable so that when they edit and save the data they enter into these fields in the database. So that they can access the data they enter next time when they open the spreadsheet.
I am a newbie to VBA in excel. Is this possible to do in VBA. If so, can you provide some sample code for me to use or some documentation that I can read and try to do this.
Any help is appreciated.
Thanks
ip