Results 1 to 2 of 2

Thread: complex merging

  1. #1

    complex merging



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have created a master file that is of different layout (i.e it contains more number of columns and more no. of rows but in a transposed way.) I want to merge my excel files into this master file provided certain conditions are fulfilled:
    My files have certain data of different companies corresponding to different years ( years in columns and variables in rows )so I have created a master file (with years in rows and the variables in columns) from the earliest year to the latest year. Now I want that the data in the excel files gets copied into the master file according to the year (I.e correct data corresponding to the relevant year).Also I want that two rows should be left empty after each company's data. I don't have time for copying and pasting the data one by one ( the no. Of companies is very large) .is there any other way/code to do this. I hope I have explained my problem
    i have attached my execel files sample and tha layout of my master file
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Crossposted.

    Please provide links to other forums that you have posted this question to.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •