Copy the data from one file and past in SLA Calculation file

[Abdul Haneef]

Hi All,

I have attached the 2 file. I want to Automate the SLA Calculation file. In SLA Calculation File given one sheet name is Result. I want to add one button in Result sheet and when we click on the button then these below mention setps need to be perform automatically. So I am requesting to all of you please write the macro code and automate my SLA calculation file.

1 Open the Wave1 file.
2 Copy the data from wave1 file and paste in SLA calculation on Wave1_Raw Data sheet.
3 Close the Wave1 file.
2 Copy the column A,H,K,M,Z.from SLA calculation on Wave1_Raw Data sheet.
3 Paste in Wave1_Modified sheet.
4 Remove the duplicate from Document column.
5 Add a Vlookup formula in Column F. =VLOOKUP(E2,'User ID'!A:B,2,0) this formula fill in all the rows (till the data available in # of rows)
6 Then make a pivot table from the Wave1_Modified sheet. and table show in the Result sheet.
1 FO/BO - Drag in Report filter
2 DcTP - Column labels
3 SalesOrg - Row labels
4 Count of Document - Value

Thanks,
Abdul Haneef

[AB33]

Abdul Haneef,
This looks a project to me.
You are unlikely to get a response until you split up your request in to 3 or 4 task at a time. You might also consider going to commercial service of this site where you will get a speed reply for all your request.

[Abdul Haneef]

Please help me out.