"This is basically to know the productivity. I have a main folder, under this i have a no. of sub folders. Each sub-folder has one excell each. Each one belongs to one person. It would have columns such as Emp_id, Case_id, Comment,Type...
Under the main folder there is another sheet where i plan to write a macro which should read all the Excells under the Sub-folders and put the total in the excell in main folder. If the Type = 'E', the case_id and Comments should also be copied against Emp id. prefer a white line after the data of each person."
Under the main folder there is another sheet where i plan to write a macro which should read all the Excells under the Sub-folders and put the total in the excell in main folder. If the Type = 'E', the case_id and Comments should also be copied against Emp id. prefer a white line after the data of each person."