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.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
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..<o></o>
Ex:<o></o>
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<o></o>
<o> </o>
Thanks in Regards,<o></o>
GV Reddy<o></o>
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.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
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..<o></o>
Ex:<o></o>
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<o></o>
<o> </o>
Thanks in Regards,<o></o>
GV Reddy<o></o>