Copy entire row to new workbook based on value from unknown column.

  • Hello All,

    I am new to the forum and need some assistance with a project I am working on. I get sent 15-20 files a week that I need one column out of based on the value "RjctStatus" in Range A:BA. The issue is that column varies from sheet to sheet.

    I need to find that value and copy that entire column to a new workbook to the next available row in column A. I have started the code to loop through all files in the folder. I have tried multiple variations of code with little to no success. I noted inside of the code which code block I need assistance with, with a bold "'This is the code block that I need help with".

    Thanks ALL!!!

Participate now!

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