Loop file merging by file name

  • I have been copy pasting the data for awhile now and looking whether is there a faster way to do this.



    Master FileFiltered File
    CaliforniaCalifornia - Temporary
    ConnecticutConnecticut - Temporary
    MassachusettsMassachusetts - Temporary
    NevadaNevada - Temporary
    New JerseyNew Jersey - Temporary
    New YorkNew York - Temporary
    OregonOregon - Temporary
    WashingtonWashington - Temporary

    * "Master File" & "Filtered File" list will expand.

    I would like to have the Filtered File data starting from row 2 to the last row (data is dyanamic) and paste it into the Master File list at the bottom after the last row which has data.
    Also I would like to have the filtered file to be deleted after copy pasting into the master file... if that's possible
    :(

    Any help will be appreciated

  • Dear royUK ,

    Thank you for your quick response.

    I hope my explanation helps you on understanding my problem.

    I would like to copy from "Oregon - Temporary.xlsx" from row 2 onwards to the last row.


    Image: Oregon - Temporary file

    Image: Oregon file

    And paste it into "Oregon.xlsx" & save the file.
    After pasting the data to "Oregon.xlsx", delete the "Oregon - Temporary file.xlsx"

  • Possibly...

    If I've been helpful, let me know. If I haven't, let me know that too. 

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!