helloakshay
New Member
Hi All
I am working on two files the master file and source file
The source file has information about volumes but only 100 rows with 3 column
Staff id queuename volumes
16001005 process A 99
16001005 process B 101
16001006 Process A 200
The master file has information about
Staff id Queuename, Volumes
*Queue name in master file has all the queue names from A-Z while in the source file we have only those queue names which operator worked in that month. So in the source file we have might 100 rows this month next month we might have 75/ 125.
So the objective here is to vlookup if staff id in master is equal to staff id in the source file and then if Q name is equal for that staff id update volumes in destination file.
Issue is the rows in source file will keep changing based work done by operators in that month and Q name will be appearing for all staff ids who worked in that month.
While the structure in master file remains the same for all staff ids and all q name whether they process or not.
Ultimately i want to update volumes in destination file
I am unable to run a vlookup through vba. so wanted u r suggestion i have attached the files.
I am working on two files the master file and source file
The source file has information about volumes but only 100 rows with 3 column
Staff id queuename volumes
16001005 process A 99
16001005 process B 101
16001006 Process A 200
The master file has information about
Staff id Queuename, Volumes
*Queue name in master file has all the queue names from A-Z while in the source file we have only those queue names which operator worked in that month. So in the source file we have might 100 rows this month next month we might have 75/ 125.
So the objective here is to vlookup if staff id in master is equal to staff id in the source file and then if Q name is equal for that staff id update volumes in destination file.
Issue is the rows in source file will keep changing based work done by operators in that month and Q name will be appearing for all staff ids who worked in that month.
While the structure in master file remains the same for all staff ids and all q name whether they process or not.
Ultimately i want to update volumes in destination file
I am unable to run a vlookup through vba. so wanted u r suggestion i have attached the files.