Hi,
I need help with a macro that uses find.

I would like to do the following:
1).Search through the Model Number column , select the appropropriate model
number
2). Search through the Units column and select the appropriate units
3). Then search through the range column and select the appropraite range
4). Copy this row to another workseet

Any suggestions?

Model Error 1 Range Units
Model1 0.03% .1V Scale Vdc
Model1 0.03% 1V Scale Vdc
Model1 0.03% 10V Scale Vdc
Model1 0.03% 100V Scale Vdc
Model2 0.03% .1V Scale mVdc
Model3 0.03% .1V Scale mVdc
Model4 0.02% 1V Scale Vdc
Model5 0.04% 1V Scale Vdc
Model6 0.05% .1V Scale mVdc
Model7 0.06% 1V Scale Vdc
Model2 0.07% 1V Scale Vdc
Model3 0.03% 1V Scale mVdc
Model4 0.02% 1V Scale Vdc
Model5 0.03% 10V Scale Vdc