Combine data from two worksheets into a new worksheet

  • I am trying to combine data from two worksheets into a new worksheet


    The macro should evaluate worksheet 1 (row 1) and find rows in worksheet 2 that have the same value in column A as worksheet 1. Then it should create a new worksheet 3 and move the row in worksheet 1 followed by the rows found in worksheet two.


    Note: Any records with the number 0 in column A of both worksheets should not be moved to new worksheet

Participate now!

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