Compare several worksheets to 1 worksheet in Excel 2016

[DThib]

Hello,

I am looking for code to take a comparison of one worksheet with all the data to the 7 worksheets with the original data.
Can someone help with a code that allows me to place a phrase with address of original next to the comparison or even onto a new worksheet?
All the data is in 1 workbook.
I would need to match several items in the column it finds in the original.

Help!

DThib

 

[Vbagreenhorn1]

i'm sure someone can help you whit that, but provide us with more info.

 

[DThib]

Each worksheet is a data run from an instrument.
Columns A-M have data.
The combined worksheet has all the data from the 7 runs.

There are column headers
I can give you a sample of the type of data if that will help.

 

[DThib]

Here is a sample of what is on all worksheets

[[TABLE="width: 1090"]
<tbody>[TR]
[TD]Sample Group[/TD]
[TD]Sample[/TD]
[TD]Assay[/TD]
[TD]Wells[/TD]
[TD]Dilution[/TD]
[TD]Concentration[/TD]
[TD]Signal[/TD]
[TD]Signal Mean[/TD]
[TD]Signal CV[/TD]
[TD]Calc Conc.[/TD]
[TD]%Recovery[/TD]
[TD]%Recovery Mean[/TD]
[TD]Calc. conc. Mean[/TD]
[TD]Calc. Conc. CV[/TD]
[/TR]
[TR]
[TD]Standards[/TD]
[TD]S1[/TD]
[TD]IL-1as[/TD]
[TD]A01[/TD]
[TD]10[/TD]
[TD]3360[/TD]
[TD]2678[/TD]
[TD]259[/TD]
[TD]4[/TD]
[TD]3539.22[/TD]
[TD]105[/TD]
[TD]102[/TD]
[TD]3424.86[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Standards[/TD]
[TD]S1[/TD]
[TD]IL-1as[/TD]
[TD]A02[/TD]
[TD]10[/TD]
[TD]3360[/TD]
[TD]2515[/TD]
[TD]259[/TD]
[TD]4[/TD]
[TD]3310.50[/TD]
[TD]99[/TD]
[TD]102[/TD]
[TD]3424.86[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Standards[/TD]
[TD]S1[/TD]
[TD]IL-2aq[/TD]
[TD]A01[/TD]
[TD]10[/TD]
[TD]60000[/TD]
[TD]3883[/TD]
[TD]3835[/TD]
[TD]2[/TD]
[TD]60889.44[/TD]
[TD]101[/TD]
[TD]100[/TD]
[TD]59988.99[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Standards[/TD]
[TD]S1[/TD]
[TD]IL-2as[/TD]
[TD]A02[/TD]
[TD]10[/TD]
[TD]60000[/TD]
[TD]376[/TD]
[TD]3835[/TD]
[TD]2[/TD]
[TD]59088.54[/TD]
[TD]98[/TD]
[TD]100[/TD]
[TD]59988.99[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Standards[/TD]
[TD]S2[/TD]
[TD]IL-1as[/TD]
[TD]B01[/TD]
[TD]10[/TD]
[TD]840[/TD]
[TD]664[/TD]
[TD]660[/TD]
[TD]1[/TD]
[TD]804.80[/TD]
[TD]96[/TD]
[TD]95[/TD]
[TD]799.08[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Standards[/TD]
[TD]S2[/TD]
[TD]IL-1as[/TD]
[TD]B02[/TD]
[TD]10[/TD]
[TD]840[/TD]
[TD]656[/TD]
[TD]6645[/TD]
[TD]1[/TD]
[TD]793.37[/TD]
[TD]94[/TD]
[TD]95[/TD]
[TD]799.08[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]


DThib