[Urgent] Creating a Macro to Copy Time sheets Data of employees into Master Sheet

Hi Guys,

I am new to Excel Programming. Now, i need to create a macro to copy the data from time sheets of different employees into the Master sheet. ie., each employee's time sheet details in to a separate sheet. if any employee fails to provide his/her time sheet details. a mail must be sent to the respective employees regarding the Time sheet submission. i am providing the sample data of my files too. please provide your suggestions.


P.S: Intentionally TS_Employee5.xlsx timesheet isn't provided. in which case, i have to send a mail to the respective employee, in order to remind him about the time sheet.

Thanks & Regards

Which are the fields from the individual TS_Employee sheets that should be copied to the master sheet?

Also, you might have to include the email code in a separate thread.

What should the sheet be named after its copied to the master sheet?

How many employees are you talking about ?

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button

This error shows that the sheet name in your source files are not matching the sheet name in the code.

You need to replace Sheet1 with the name of the sheet in the TS_Employee...files.

1Thakur,

Ensure that you change the path in this line

Please Login or Register  to view this content.

to reflect your system path where the files are.