sandhya jayanthi
New Member
Hi Hui,
Please find the attached two documents for your easy reference i need to open specified excel files and copy the specific (range should mention) into master file (at specified range) in single work.
If i specific specific file name it should place into different work sheet as per the specified range.
For your easy reference i am attaching two files:
1) Source file i selected with different colors.
2) Concern colored text to be copied into master work sheet.
3) For copying the data it can take column "D" and "E" references or as per your wish can take the range references.
4) If I open a specific file that open file should copied into different worksheet.
5) The color reference given for your easy understanding.
Kindly resolve this problem.
Please find the attached two documents for your easy reference i need to open specified excel files and copy the specific (range should mention) into master file (at specified range) in single work.
If i specific specific file name it should place into different work sheet as per the specified range.
For your easy reference i am attaching two files:
1) Source file i selected with different colors.
2) Concern colored text to be copied into master work sheet.
3) For copying the data it can take column "D" and "E" references or as per your wish can take the range references.
4) If I open a specific file that open file should copied into different worksheet.
5) The color reference given for your easy understanding.
Kindly resolve this problem.