Hello
I am looking for macro to provide a option to upload one excel file (which have standard format and common columns),from that file i would want to copy the details and paste those in different work sheet with desired format.
More in detail, I receive report in excel format with same columns, but I need to take only particular columns and copy those and paste it in the destination format, can anyone suggest on this..
Ex:
Input file with sheet1 have in range A – Employee number, range B – Employee name, range F- Country, destination file have A-employee number,B=Employee name, C-Country like that

Thanks in Regards,
GV Reddy