• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Consolidating different excel files into on excel worksheet

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.
 

Attachments

  • CONSOL.rar
    39.7 KB · Views: 0
Back
Top