Export 2 coloums data from 1 to 30 sheet to one new excel or in a different new sheet1

[Dhamu13]

Dear Friends

Kindly help to export data like name and percentage from all the sheet (30 sheets) to a new file or in a different sheet.

E.g

Name project target ,weeky %, and monthly percent% ,present, absent are there in all sheet but i want to export only Name and monthly percentage to different excel or different sheet in same excel.

Kindly help me..

[VKS]

Hello Dhamu,
You may find this link very useful.

Best Regards/VKS

[Dhamu13]

Thanks a alot..