Need a macro for creating payslip using auto vlookup and inserting and renaming sheet

Hi all

I have created a sample payslip data using vlookups for one emmployee

I request a macro for inserting sheet(It will rename by emmpcode)

The macro has to create 1 sheet for each employee and will create 50 sheets if the no of employess for 50 for the month.

can any one help on this.

Thanks & Regards
N.Srinivasan

Hi
Thanks a lot sir.
It is working fine Sir,It give me a great relief. My words are really unexpresable.
Only i request one improvision on this . I need to delete existing payslip files manually.
I tried manually deleting the files and run the macro for creating the files.
Is it posssible only to delete exising(payslip files) and not not the data or template.

Thanks & Regards
N.Srinivasan

Dear Sir,

Thank ton. It is extreemely working fine.

Thanks a lot.

Sorry to trouble you again

I had made one more request for macro for comparing 2 paysheets.(using vlookups
I shall be greateful if some experts like you can give me relief.(when you find time sir)
The file was uploaded on the same date and time of this request.

Thanks & Regards
N.Srinivasam