I tried to record the macro for the same.
but the data vary from columns to column in the files which i got through email.
For Eg.
PPID last nam first name EMPID Status
123456 him him 5646 complte
568974 goyal goyal 5649 not comp
12546 maky maky 5689 complte
45886 dame dame 4578 not comp
365248 flaok flaok 2541 complte
1325843 tyag tyag 3652 complte

this is the data which comes under different different format, by changing the names of header,
i am looking for a macro which prompt me to choose the columns which i required and paste that selection to the new file.
Thanks in advance