Inserting Time sheet Data in to Master sheet Based On the Condition Using Macros.

See more:

MS-Excel

macros

Hi Guys,

I have a Master sheet(Excel Sheet) which contains the columns Resource name, No: of Hours, File names and Mail id. In this sheet, i have two types of employees. ie., Permanent and temporary. we can identify the employee type based on their file names.(time sheet names). for example, permanent employee's file name will have a format such as "TS-KKCMania-hyd-" and temporary employee's file name will have a format such as "KKCMania". All the time sheet's of temporary employees are available in the master sheet itself. but, i need to fetch the permanent employees's time sheet's from other location.

The problem here is, i need to display all the time sheet's of both the temporary and permanent employye's in the same order as they were displayed in the master sheet(as like the order in Resource Name column) followed by the Consolidate Sheet.

The Sample Data in the below link will give you a more clear picture.

Click here to Download Sample Data Files