my work need me often search the excel picture sheet to look for the cassette No. and then acquire the detail information from the database through the cassette No.
I think this should be 3 step:
1. list the cassette No#
2. copy the cassette No#, and paste into the QMF software, and then Run database to acquire the detail data.
3.copy the detail data from the QMF result, paste into the excel Summary sheet.
So how could I auto finish the job with excel function, such as VBA or any ways.
I have upload a excel example, but for job secret, I delete some information.
thanks everyone give my good idea and wish I can over the boring job.
I think this should be 3 step:
1. list the cassette No#
2. copy the cassette No#, and paste into the QMF software, and then Run database to acquire the detail data.
3.copy the detail data from the QMF result, paste into the excel Summary sheet.
So how could I auto finish the job with excel function, such as VBA or any ways.
I have upload a excel example, but for job secret, I delete some information.
thanks everyone give my good idea and wish I can over the boring job.