I have prepared a payslip in excel and now I want to make separate file for each employee.

I have list of employee with there Emp code and payslip which is linked with employee code through Vlookup i.e. when we enter employee code all relevant data populates where ever required.

Now what I want is in the attached sheet

Link Cell No. C7 with list in Employee List sheet and create new file by moving Sheet P and name it what appears in Cell No. C7.

Macro should do the following:

Link C7 with List one by one and do the following every time

Move sheet P as create a copy

Select all (Ctr+A) and paste it as value

Save a file at assigned location named with employee code

Repeat this till the list ends.

So, what's your question? Let's see your work so far.

If you're looking for someone to do it for you from beginning to end, you should consider Commercial Services.