Hi All, 

Struggling to find VBA/Macro code that will suit my needs. I have a file that will become the parent file for a new system. In this file there is roughly 1600 rows already filled out. There is then a separate file call it the donor file that has information that needs to be copied to the parent file.  I need a macro that can pull this information from the donor file and copy it to the parent. However, there is 3 columns each cell within these columns having different criteria that is required to match between the two files prior to moving the information. Given the criteria matches I then need to insert the number of rows that have matching criteria in the parent file. Then those newly inserted rows needs to be filled with information from 2 different columns within the given donor file as well as the 3 different criteria set by the parent file. 

In short the goal is to make a tree like file. Where the inserted rows have information from the only the row above and are the number of rows inserted is based on the number of rows that match the criteria set. The inserted rows then need to be filled with 2 pieces of information from one file and 3 pieces of information from another file. 

I have been struggling to find an solution to this problem, please send help…😭😂

​Hi All,  Struggling to find VBA/Macro code that will suit my needs. I have a file that will become the parent file for a new system. In this file there is roughly 1600 rows already filled out. There is then a separate file call it the donor file that has information that needs to be copied to the parent file.  I need a macro that can pull this information from the donor file and copy it to the parent. However, there is 3 columns each cell within these columns having different criteria that is required to match between the two files prior to moving the information. Given the criteria matches I then need to insert the number of rows that have matching criteria in the parent file. Then those newly inserted rows needs to be filled with information from 2 different columns within the given donor file as well as the 3 different criteria set by the parent file.  In short the goal is to make a tree like file. Where the inserted rows have information from the only the row above and are the number of rows inserted is based on the number of rows that match the criteria set. The inserted rows then need to be filled with 2 pieces of information from one file and 3 pieces of information from another file.  I have been struggling to find an solution to this problem, please send help…😭😂  Read More

​