Compile Results from Multiple Worksheets into Summary Sheet with mismatched and replicate 1st row IDs

  • Hi,

    I am trying to combine calculated results (5 different tests) from multiple worksheets into a final summary sheet, but the row ID's (A:A) are not in identical positions and are replicated because I run the tests in triplicate and then average those measured values. I want to get those averaged values for each different test for each unique ID in Row A into the summary sheet and not have to grab every iteration of the ID to be copied along with it.

    I am a complete beginner to VBA (I started 3 days ago) and would appreciate any help I could get. I have attached a sample version of the workbook I am working on with some example data put in to show what I am trying to explain.:)

Participate now!

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