Hey guys,

I am running a spreadsheet that takes values from the first sheet, makes a copy of my second sheet which is a template, renames that sheet to a certain name that is from a cell in the first sheet, and then populates the sheet with corresponding values from the first sheet. This allows me to put in about 10 core values (ten col by one row) for each "test" that I run over and over again without needing to keep making new sheets. Once I have run about 50 tests with their 10 values (all on the first sheet), I run my macro and it outputs 50 data sheets with all of the corresponding values from each test in the correct cells.

I am currently running this test by serial number, so each sheet is named with the corresponding serial number for that part. On each data sheet there is a place that the serial number goes. So sheet one is named SN001 and on the data sheet under the serial number there is 001 in the box. Up to this point I have it working exactly how I want it. But now I am kind of lost trying to figure out how to do what I want next.

For the next part I am wanting to import values from another spreadsheet that is output from another part of the test procedure. This test procedure is run by serial number as well and it has about 12 tests that are either "pass" or "fail." Basically I am needing to populate my data sheets with not only the info on my first sheet, but the spreadsheet from this other test.

I am not sure if this is better done with a macro, or with a formula within the correct cell on my template sheet.

The way I envision it working is this:

It would open the second spreadsheet and search down the first column until it finds a perfect match in serial number to a value in a cell on my data sheet. When it finds that number, it will jump over x number of columns and maybe 1 row down (haven't fully formatted the output of the second spreadsheet), copy the contents, and then paste it back into my data sheet in a given cell. It would then do this for each cell that requires values from the second spreadsheet. Since it would do this 600 times or so for a data set of 50, I would like the sheet to stay open throughout, and have it closed manually at the end.

I hope this is clear enough, and whatever thoughts you guys might have will be much appreciated!