sindhuja
01-03-2012, 10:01 AM
Hi,
Can anyone please assist on the below requirement.
I have a master file with all the error type with the department associated with each one. File will consist of almost 5000 error types.
I have another file in which only the error type will be given in column G for which we need to get the related department by using ctrl + F in the master sheet and paste the respective department in the column D of second file.
Since the second file has huge number of rows, it takes lot of time to complete the task.
Can this be done using macro without opening the file saved in the shared area.
I have attached 2 spreadsheet - Master sheet from which we need to find the dept for the value (in column L of file named Error).
Error spreadsheet will be open whereas the master spreadsheet is saved in the shared drive.
Pls assist.
-sindhuja
Can anyone please assist on the below requirement.
I have a master file with all the error type with the department associated with each one. File will consist of almost 5000 error types.
I have another file in which only the error type will be given in column G for which we need to get the related department by using ctrl + F in the master sheet and paste the respective department in the column D of second file.
Since the second file has huge number of rows, it takes lot of time to complete the task.
Can this be done using macro without opening the file saved in the shared area.
I have attached 2 spreadsheet - Master sheet from which we need to find the dept for the value (in column L of file named Error).
Error spreadsheet will be open whereas the master spreadsheet is saved in the shared drive.
Pls assist.
-sindhuja