gvreddyhr
02-07-2012, 08:51 AM
Hello
I am looking for macro to provide a option to upload one excel file (which havestandard format and common columns),from that file i would want to copy thedetails and paste those in different work sheet with desired format.
More in detail, Ireceive report in excel format with same columns, but I need to take onlyparticular columns and copy those and paste it in the destination format, cananyone suggest on this..
Ex:
Input file withsheet1 have in range A – Employee number, range B – Employee name, range F-Country, destination file have A-employee number,B=Employee name, C-Countrylike that
Thanks inRegards,
GV Reddy
I am looking for macro to provide a option to upload one excel file (which havestandard format and common columns),from that file i would want to copy thedetails and paste those in different work sheet with desired format.
More in detail, Ireceive report in excel format with same columns, but I need to take onlyparticular columns and copy those and paste it in the destination format, cananyone suggest on this..
Ex:
Input file withsheet1 have in range A – Employee number, range B – Employee name, range F-Country, destination file have A-employee number,B=Employee name, C-Countrylike that
Thanks inRegards,
GV Reddy